Viewing 15 posts - 1 through 15 (of 21 total)
Wondered whether this might be a trick question, but the correct answer seemed pretty obvious.
Glad to know I can't accidentally drop tempdb ...
April 24, 2015 at 4:13 am
Nice question - neatly demonstrates the two uses of the "char" keyword in T-SQL.
Also, I managed to get it right without looking it up or loading up SSMS, which is...
February 11, 2014 at 2:53 am
Firstly - well done on dealing with the plagiarism issue so openly - and a free book giveaway never hurts!
We use windows functions extensively in our code base, particularly for...
December 5, 2013 at 3:57 am
I think there's an understandable negative attitude towards MS certifications amongst a lot of experienced developers. That's probably better than taking an overly rosy view of what certification can...
September 17, 2013 at 2:42 pm
"The SQL Server Database Engine recognizes any unique string that is part of the configuration name."
Wow, I did not know that. Good question, I always like it when I...
August 30, 2013 at 2:37 am
David.Poole (8/28/2013) My expression would be "Kalen Delaney".
I was about to say pretty much exactly the same thing. Having seen her speak at this year's SQLBits, I can...
August 28, 2013 at 4:50 am
As many others have said - great question, probably the best I've seen on the site. Challenging without being pedantic.
I did get it wrong but understand why and definitely...
August 8, 2013 at 6:46 am
David.Poole (6/5/2013)
June 5, 2013 at 2:00 pm
Hugo Kornelis (4/3/2013)...The code was long and complicated, making this question more an exercise in parsing code....
...which personally I quite enjoyed in this instance, but agree that Hugo's recommendations to...
April 3, 2013 at 5:40 am
Hugo Kornelis (2/7/2013)
paul s-306273 (2/7/2013)
Steve - 0 points to you for creating a view using 'select *'...😛
So how should Steve have made a QotD about the dangers of select *...
February 7, 2013 at 3:14 am
roger.plowman (1/30/2013)
if your application makes extensive use of seperate data, it would seem you would really need it. 🙂
Yes - exactly why I thought this was a good question. ...
January 30, 2013 at 8:08 am
Good question, not too difficult but required taking into account PK, check constraint and data type which meant it took me a few seconds.
Obviously some valid criticisms of the explanation...
January 29, 2013 at 4:36 am
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..need to read it again ..
+1
November 20, 2012 at 1:57 am
To get back to the original topic...
From my experience of working in a small (3-man) development/ IT team, easier access to the cut-down versions of SQL Server should hopefully mean...
November 15, 2012 at 2:58 am
Viewing 15 posts - 1 through 15 (of 21 total)