Apr 17, 2009

SELECT Yourself

Today’s question is very simple.

If you were any type of T-SQL query, what type would you be?

Personally, I see myself as the type of query that looks normal enough, but causes all sorts of problems once you let it loose in production, but you don’t want to kill it because you are afraid to wait for the rollback.

sqlrockstar Asides, Question of the Week 10

http://www.straightpathsql.com/blog Mike Walsh

This would be a better “stupid interview question” than the normal “stupid interview questions” (“what kind of vegetable or animal would you be? “)

As for a SQL Query that I would be… I have a lot of interests that while different, have some common themes between them. There are some overarching principles I try to live by.

So I would probably have a CTE of my common principals, values, etc. and then find the commonality between the interests and do a few unioned selects.
http://davidtate.org/blog David

Easy – Undocumented sql commands running inside a trigger that deletes uses x0BADCAFE as the first bit of its @sql_handle.
http://www.ford-it.com/sqlagentman Tim Ford

SELECT D.Lname + ‘, ‘ + D.Fname
FROM DBPros D
INNER JOIN
http://www.ford-it.com/sqlagentman Tim Ford

Damn TABS!
wnylibrarian

I’m some sort of stored procedure that would calculate some statistical information to be used for some sort of detailed analysis report for someone. Sort of like baseball data. What is the batting average of left-handed hitters against left-handed pitchers after 9 p.m. when the humidity is <= 58% and the wind is < 9 m.p.h.

sp_ReferenceLibrarian
http://www.ford-it.com/sqlagentman Tim Ford

SELECT D.Lname + ‘, ‘ + D.Fname
FROM DBPros D
INNER JOIN People_Statuses PS ON D.dbp_id = PS.dbp_id
INNER JOIN Statuses S ON PS.status_id = S.status_id
INNER JOIN People_Personalities PP ON D.dbp_id = PP.dbp_id
INNER JOIN Personalities P ON PP.pers_id = P.pers_id
INNER JOIN People_Skillset PS ON D.dbp_id = PS.dbp_id
INNER JOIN SkillSet SS ON PS.skillset_id = SS.skillset_id
INNER JOIN People_ExtracurricularActivities PEA ON D.dbp_id = PEA.dbp_id
INNER JOIN ExtracurricularActivities EA ON PEA.ea_id = EA.ea_id
WHERE
S.status_desc IN (‘chillaxed’, ‘stressed’) –Yes, can be both aka “tech bi-polarism”
AND P.personality_desc = ‘confident’
AND SS.skillset_desc IN (‘DBA_General’, ‘SSIS’, ‘Internals’, ‘DMV’, ‘Development’, ‘TSQL’, ‘VB’, ‘Agent’)
AND EA.ea_desc IN (‘Skiing’, ‘Gaming’, ‘Reading’, ‘Photography’, ‘Volunteerism’, ‘Coffee Snobery’, ‘Zymurgy’, ‘Cooking’, ‘Technogeekery’, ‘Gardening’, ‘Parenting’, ‘Fitness’)
http://jeremiah.peschka.myopenid.com Jeremiah Peschka

I’d be a SHRINK DATABASE.

SQLBatman

well, that explains your fragmented state of mind

http://www.brentozar.com Brent Ozar

I’d be INSERT INTO dbo.YourMom.
Sanjeev Kumar

I would be

DROP Database..