Viewing 15 posts - 466 through 480 (of 583 total)
charles evans (10/17/2011)
I wonder if this works the same way without ANSI Nulls? I'm too lazy/busy to try it out.
It works the same with SET ANSI_NULLS OFF (Deprecated feature,...
October 18, 2011 at 5:34 am
SKYBVI (10/17/2011)
It should be 1 and 2 only
beacuse only the constraint is violated,
the sql statement is terminated.
it doesn't look for other statements...
just goes out of...
October 17, 2011 at 7:32 am
rmechaber (10/17/2011)
October 17, 2011 at 7:29 am
SQLRNNR (9/7/2011)
Nice question. Thanks to DBCC Timewarp we were able to answer the Oct 14 question over a month early. :-D:-D:-D:-D
I had forgotten about this question. So, I was...
October 14, 2011 at 7:08 am
Easy enough (and straight forward) that I thought it was Monday. Thanks Steve!
October 13, 2011 at 5:35 am
Nice one! I almost missed it, but my spidy sense told me to look at the question again. Thanks.
October 10, 2011 at 6:17 am
This will help the swelling go down after yesterday's injuries. Thanks for the question!
I didn't learn as much as I have with other QOTDs, but sometimes it's nice to...
October 6, 2011 at 5:36 am
I said C only: Some other attribute B is fixed by a set including A but by no subset of that set - which is clearly true.
Couldn't get the other...
October 5, 2011 at 6:05 am
SQL Kiwi (10/3/2011)
Thomas Abraham (10/3/2011)
So, now I'm a bit confused. Just when am I supposed to use table variables?
Whenever they suit the requirement better than a temporary table 🙂
Wayne Sheffield...
October 3, 2011 at 12:25 pm
Thanks to all, including Ron, Mark & Jack, for their responses.
I had just switched over to using more table variables, and will be more reluctant to use them going forward.
October 3, 2011 at 8:11 am
sknox (10/3/2011)
The reason the table variable code is so slow is...
October 3, 2011 at 7:53 am
Oops, where are my manners. Thank you sir, may I please have another? (Question, that is.)
October 3, 2011 at 6:09 am
I got it wrong, so I tested it on my own system. (2008 R2 - 2005 not available)
Results for table variable, in ms: 80800, 80203, & 79523
Results for temp table,...
October 3, 2011 at 6:08 am
Nice question. Just the right amount of difficulty for my morning starter. Thanks.
September 29, 2011 at 5:47 am
As I work in a shop with multiple DBA's, I don't always get to "fiddle" with the configuration. Definitely learned something today. Thanks for the question.
September 28, 2011 at 5:49 am
Viewing 15 posts - 466 through 480 (of 583 total)