Viewing 13 posts - 16 through 28 (of 28 total)
I may be wrong here, but this bug could have been around even longer. SQL2008 doco http://msdn.microsoft.com/en-us/library/ms188029(v=sql.100).aspx also shows the same comment about the effect of GROUP BY clause on...
May 12, 2013 at 7:02 pm
Tom, yes I noted the deprecation issue - it's not that ...
Question says "Which of the following hints require the word WITH? (choose 3) "
Explanation says "table hints ROWLOCK,...
April 28, 2013 at 11:48 pm
the joys of answering early :pinch: -
The QotD question states "Which of the following hints require the word WITH? (choose 3) "
I don't use Table Hints that often,...
April 28, 2013 at 7:16 pm
CAUTION: Assumes you have not set your users 'default schema' to point to something other than 'dbo' - otherwise ....
1. table T1 will be...
February 27, 2013 at 8:36 pm
As it stands, the question is poorly phrased. Even if one part of the solution is clearly false, the boolean 'OR' operation makes the statement true if the other part...
February 18, 2013 at 9:26 pm
mtassin (1/28/2013)
Christian Buettner-167247 (1/28/2013)
Don't have AdventureWorks either... 🙁You know, google and 5 minutes of download time and you can get it... MS puts it up on Codeplex for you
Some of...
January 28, 2013 at 3:29 pm
Thanks Dwain,
OK it's not pretty because of all the slicing and dicing of the geometries into sub-geometries, then points, then X's and Y's then assembling into a formatted string,...
January 17, 2013 at 10:22 pm
If I understand the Geometry construct correctly, (and I'm not claiming to be an expert here, this is just based on frustrating experiences) the latitude and longitude values are stored...
January 17, 2013 at 7:08 pm
A couple of points on this post, (given it has been here unanswered for quite a while, the info may be a bit late to help for the original post,...
January 17, 2013 at 5:06 pm
http://msdn.microsoft.com/en-us/library/ms190190.aspx - Back Up and Restore of System Databases -
The linked document states "You cannot backup the tempdb system database."
:ermm:
I guess you could read that as "why are...
May 28, 2012 at 10:40 pm
Got this right, on the assumption 'SQLAgentAgentRole' was meant to be 'SQLAgentReaderRole', as none of the other answers were correct, and 'SQLAgentAgentRole' doesn't seem to exist.
March 21, 2012 at 9:19 pm
OK now I'm really confused - the document referenced in the 'Explanation' (http://msdn.microsoft.com/en-us/library/ms191203.aspx) has a 3 step heirarchy -
1 - A database option overrides an instance option.
2 -...
February 1, 2012 at 6:59 pm
SELECT NUM, SIGN(NUM)* FLOOR(ABS(NUM) * 20)/20 AS ROUNDUP
This will handle negative and positive values in the same manner
February 1, 2012 at 6:31 pm
Viewing 13 posts - 16 through 28 (of 28 total)