Viewing 15 posts - 1 through 15 (of 61 total)
Thanks jghali and keep them coming! I saw this question and knew I'd get it wrong because some parts were vague, but vague questions are what we deal with...
July 21, 2010 at 11:06 am
This is a great question, if nothing else for the comments it's generated. It contains both a CTE and a cross join, and it appears that some are unfamiliar with...
March 3, 2010 at 6:10 am
Dealing with xp_cmdshell is even easier than this... it shouldn't be enabled. Article really should have mentioned that somewhere; "...can be a security problem in some environments" is an understatement.
February 2, 2010 at 5:32 am
fallenstudent (1/29/2010)I also tested the code and got 1,1.So I would have had the wrong answer even testing the code?
So I would have had the wrong answer even testing the code?
Nobody can tell if you would have had the right or...
January 29, 2010 at 5:43 am
Another QOTD where either the answer is "It depends" and/or inadequate information is given. I knew that the answer was (x,1) but there's not enough information to determine x. If...
January 29, 2010 at 5:40 am
I'll chime in as well to say that IN is an operator. See BOL for list of Logical Operators
January 7, 2010 at 5:52 am
This makes me think of Anton Chigurh's quote from No Country for Old Men "That's foolish. You pick the one right tool."
December 4, 2009 at 5:58 am
@jeff Moden - Can't do anything about you getting "knocked" but I can say Thanks for your always thoughtful and insightful posts that add a great deal to...
November 29, 2009 at 3:48 pm
I had to laugh at the LOLCats spelling of Enterprise as Enterprize! Too bad the question wasn't written in LOLCats as well... "I can haz SQL j0bz in which edishunz?":-D
November 29, 2009 at 10:47 am
Good question, the "sp_compatibilitylevel" choice almost tricked me into getting confused with sp_dbcmptlevel (which gives the compatibility level if you just pass the database name parameter alone).
November 10, 2009 at 5:44 am
Carlo Romagnano (11/3/2009)
Noel McKinney (11/3/2009)This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.
Noel McKinney (11/3/2009)
November 3, 2009 at 6:32 am
This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.
November 3, 2009 at 6:00 am
Thanks Gail for mentioning that "When an index scan is done on the clustered index, it’s a table scan in all but name." Many folks think that performance is always...
October 26, 2009 at 7:15 am
Tom Garth (9/30/2009)
SQL Server indexes are organized in a B-tree structure. The "B" in B-tree stands for what?
The question is specifically referring to SQL Server indexes. The Microsoft definition would...
September 30, 2009 at 10:57 am
Fill factor of 100 with PAD_INDEX = ON for reference (lookup) tables. While the fill factor of 100 is the same as 0 I like that this syntax is more...
August 14, 2009 at 9:31 am