Viewing 15 posts - 16 through 30 (of 93 total)
Darn, one of the few times I didn't Google first, just guessed and got it wrong. :-D. I don't care about points. QotD is a great way for me to...
July 30, 2012 at 5:00 pm
amit_adarsh (10/13/2011)
is Microsoft dropping support for BIDS ?
No, from my understanding, they plan to address this issue in an upcoming release of SQL server.
October 13, 2011 at 8:33 am
vk-kirov (10/10/2011)
codebyo (10/10/2011)
After the EXCEPT, only the number 4 remains. So where...
October 11, 2011 at 10:15 am
Ernie Schlangen (8/24/2011)
August 24, 2011 at 10:38 am
Not sure if this will help or not but I see your CX_BasketItem_Owner index is clustered. Since this column is a unique identifier I don't think it makes a good...
May 5, 2011 at 9:19 am
I am not an expert at this but I noticed that you are doing a delete using UserID and this column does not appear to be indexed. I think that...
May 4, 2011 at 5:54 pm
Haha got it wrong because I didn't know what the version store is. Nice question. Thanks!
April 7, 2011 at 10:00 am
SanDroid (3/24/2011)
rmechaber (3/24/2011)
These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?
Rich,...
March 24, 2011 at 3:23 pm
rmechaber (3/24/2011)
Sean Lange (3/24/2011)
rmechaber (3/24/2011)
March 24, 2011 at 10:04 am
Ryan Fitzgerald (3/18/2011)
Bull, theres a comma at the end of the create. That will fail.
In my best master Yoda voice, "Sure of this, are you?"
March 18, 2011 at 8:57 am
I thought about answering Oracle just for the fun of it but my LOVE for points won out.:-)
February 14, 2011 at 12:44 pm
Hugo Kornelis (12/9/2010)
kevin.l.williams (12/9/2010)
By the way, how many of you read the forum comments and stop after you get to Hugo's? 🙂
:laugh:
If that number is significantly large, I'll have to...
December 10, 2010 at 8:19 am
Nils Gustav Stråbø (12/9/2010)
64% got it right. Yeah, right!! How many cheated and ran the T-SQL code?
I cheated and got it right!
By the way, how many of you read the...
December 9, 2010 at 9:37 am
mtillman-921105 (10/19/2010)
October 19, 2010 at 10:30 am
Oleg Netchaev (8/23/2010)
This is by design and has also been covered many times in recent QotDs. Forgetting to specify the size when declaring a local variable results in size defaulting...
August 23, 2010 at 11:00 am
Viewing 15 posts - 16 through 30 (of 93 total)