Viewing 15 posts - 181 through 195 (of 673 total)
Steve Jones - SSC Editor (8/10/2011)
Excellent question, Ron. I've used this type of demo in presentations before.
Did you use a script that gave the wrong result? 😛 😉
August 10, 2011 at 9:27 am
O yeah.. Since over 77% of those that answered today obviously had the same issue with the same mistake in the script I am sure we would all like our...
August 10, 2011 at 8:35 am
:sick:This is ABSOLUTELY a depends trick question. It ABSOLUTELY depends on if you correct the error in the script that was listed. Also your DB settings change the results. ...
August 10, 2011 at 8:29 am
GilaMonster (8/2/2011)
Personally I prefer clustered index to organise the table and nonclustered indexes for data access.Shameless plugging of my own article... http://www.sqlservercentral.com/articles/Indexing/68563/
No shame in pointing out the truth when...
August 9, 2011 at 11:47 am
SQLBalls (8/9/2011)
Sorry about that guys,This is my first Published Question, I'll make sure to write in a Check All that Apply next time!
You did fine. No need to apologize.
Check...
August 9, 2011 at 8:18 am
Nice question. Really liked the "Trick Question" part since this was the exact oposite of a trick question.
August 9, 2011 at 8:09 am
Great Question. Saw that your NOT IN had only one result and NOT 😉 two right away.
August 5, 2011 at 2:14 pm
Tom.Thomson (8/5/2011)
john.arnott (8/5/2011)
Cliff Jones (8/5/2011)
I thought this question was about using approximate data types so got it right for the wrong reason.
I would hope that most viewers of this understand...
August 5, 2011 at 2:12 pm
SQLkiwi (8/4/2011)
SanDroid (8/4/2011)
August 4, 2011 at 12:41 pm
SQLkiwi (8/4/2011)
SanDroid (8/4/2011)
"Code to enforce Business Rules should not be in SQL!"Some days, I would go further:
"Code
to enforce Business Rulesshould not be in SQL!"
Nice... 😛
August 4, 2011 at 12:35 pm
SQLkiwi (8/4/2011)
SanDroid (8/4/2011)
However the count of user that can re-create and users that think...
August 4, 2011 at 12:31 pm
SQLkiwi (8/4/2011)
sknox (8/4/2011)
While it's in many ways better than IsNumeric, TRY_CONVERT does have some problems.
Oddly enough, this is exactly the stance I took a week or so ago in a...
August 4, 2011 at 12:29 pm
Tom.Thomson (8/4/2011)
August 4, 2011 at 12:18 pm
Daniel Bowlin (8/4/2011)
August 4, 2011 at 12:10 pm
Nice question. Simple and makes a good point on Conversions.
August 4, 2011 at 12:03 pm
Viewing 15 posts - 181 through 195 (of 673 total)