Viewing 15 posts - 31 through 45 (of 78 total)
lcajui (3/17/2015)
Koen Verbeeck (3/16/2015)
Can only create nonclustered columnstore index in SQL Server 2012
This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not in...
March 17, 2015 at 8:44 am
Xavon (3/9/2015)
RLilj33 (3/9/2015)
"data_type
Is the data type of the identity column. Valid data types for an identity column are any data...
March 9, 2015 at 11:07 am
Thanks for the question Sasidhar.
2nd Edit: Apologies. My first edit accidentally removed my original post:
This one threw me off. Can someone explain BOL (https://msdn.microsoft.com/en-us/library/ms189838.aspx):
"data_type
Is the data...
March 9, 2015 at 7:08 am
This one threw me off. Can someone explain BOL (https://msdn.microsoft.com/en-us/library/ms189838.aspx):
"data_type
Is the data type of the identity column. Valid data types for an identity column are any data types of...
March 9, 2015 at 7:02 am
Thanks for the question. I wasn't aware of this restriction, so I learned something new today.
P.S. As a data professional, I prefer to use the term 'junque'. 😛
March 6, 2015 at 7:51 am
Carlo Romagnano (2/27/2015)
Now, I want to try!😀
+1
February 27, 2015 at 7:13 am
Toreador (2/26/2015)
I made myself finish the first book but it wasn't a patch on the original so...
February 26, 2015 at 9:42 am
My takeaway is that the Ultimate Answer to Life, the Universe, and Everything is not, in fact, 42 but is instead '-'. Meaningful when one considers the answer is...
February 26, 2015 at 7:04 am
jshahan (2/11/2015)
This is an excellent question. Simple example that teaches a very important point.
Agreed. It would be nice if the actual answer was one of the options 😀
February 11, 2015 at 8:58 am
rob.bailey 52577 (2/11/2015)
Answer is 5, the first statement, there is a space after the *, not in the last.
+1
February 11, 2015 at 7:25 am
ZZartin (2/2/2015)
Why are we getting so many count with null questions recently?
1. Good review
2. Helps those less experienced
February 2, 2015 at 9:02 am
Hany Helmy (2/1/2015)
Maybe tomorrow QoTD will be:
COUNT(*) AS MyCount
And MyCount value will be 2 in this case (*) for the Null rows 😛
Almost got it wrong for *assuming* the...
February 2, 2015 at 7:21 am
SQL Easter Egg (sort of)! 😛
Thanks for sharing; didn't know that either. Anyone see any practical application?
January 30, 2015 at 7:24 am
A good (incorrect) alternate answer would be 5. Just to make one think a little harder. 😎
January 21, 2015 at 7:27 am
Thanks for the question. I was looking for the earliest occurrence for each author so selected the wrong answer. Must be Monday - need more coffee. 🙂
November 24, 2014 at 7:02 am
Viewing 15 posts - 31 through 45 (of 78 total)