Viewing 15 posts - 406 through 420 (of 819 total)
I couldn't believe!
I never expected this kind of question!
It is the same as:
any number multiplied by 0 returns ZERO,
so, you assume that any number added to zero should return ZERO!
:w00t:
November 8, 2013 at 1:06 am
murray-906152 (11/6/2013)
you state 'NOTE: You will notice that James was case insenstive (COLLATE SQL_Latin1_General_CP1_CI_AS )' in your answer but this is very much site specific.
(I answered on the basis that...
November 7, 2013 at 12:50 am
It is recommended that you set the clusters to 4kb.
Thanks! 🙂
November 6, 2013 at 3:05 am
Till now "Ask a co-worker?" is 0%.
I am really surprised!
😛
October 24, 2013 at 12:59 am
palotaiarpad (10/17/2013)
Is it a useful knowledge?
Yes, it is.
Sometimes, store procs run slow because of parameters sniffing and obsolete query plan.
If you recompile, store procs may run better.
October 17, 2013 at 1:32 am
DATALENGTH provides exact length of the field if it is fixed length. If the field is of variable length, it returns the length of the data in the field
It's...
October 11, 2013 at 1:08 am
Too much easy!
Thanks for TWO free points.
October 7, 2013 at 1:11 am
Ford Fairlane (10/3/2013)
Not a big fan of questions involving deprecated features, that never seem to go away.
+1
October 3, 2013 at 1:25 am
sknox (10/1/2013)
Guessed optimistically.
Got it wrong.
Can anyone explain why this should still be around when CLR has been available to replace its functionality since...
October 1, 2013 at 8:12 am
Viewing 15 posts - 406 through 420 (of 819 total)