Viewing 15 posts - 16 through 30 (of 191 total)
trevor.ball (11/3/2014)
...to make the correct answer less obvious
Which correct answer? There are three of them:
a) Query 1 will run successfully [true]
b) Query 2 will run successfully [also true]
c) Both...
November 3, 2014 at 8:03 am
Yes, I agree this seemed fairly obvious, but the fact that there are three correct answers (the first three options are all true) and I'm only permitted to choose one...
November 3, 2014 at 7:10 am
Apparently, while variable declaration occurs at compile time, inline assignment does not. Good to know.
ron
August 5, 2014 at 6:23 am
That was it. I didn't think to specify a column list in that part of the statement. (So yes, I was doing something stupid.) Thank you so...
March 20, 2014 at 1:06 pm
Just to pre-emptively answer a couple of likely questions...
1. I've confirmed that the column list in that statement matches the complete list in the SecuritySettings table, and in the correct...
March 20, 2014 at 1:04 pm
Stewart "Arturius" Campbell (3/11/2014)
ronmoses (3/11/2014)
"The columns in new_table are created in the order specified by the select list."
However, http://technet.microsoft.com/en-us/library/ms188029.aspx says...
"Specifying an...
March 11, 2014 at 6:23 am
The answers appear to suggest that the following is true:
"The columns in new_table are created in the order specified by the select list."
However, http://technet.microsoft.com/en-us/library/ms188029.aspx says...
"Specifying an ORDER BY clause does...
March 11, 2014 at 6:06 am
Richard Warr (3/6/2014)
March 6, 2014 at 7:16 am
JohnFTamburo (2/3/2014)
What's blocking it?
Some service I know nothing about. I've brought it to the attention of the appropriate folks.
thanks!
ron
February 3, 2014 at 11:58 am
JohnFTamburo (2/3/2014)This may sound weird, but does sp_who2 show the SPID that is running the create database blocked? If no, do you see the I/O counts increasing?
Hmmm... it is...
February 3, 2014 at 11:43 am
sqlsniper (2/3/2014)
Looking at the size of the files, the instant file initialization will probably also shave off some time. Ofcourse there could be considerations to not enable that option.
At this...
February 3, 2014 at 11:29 am
Thank you John. I was basically looking for any answer other than, "Oh my no, something's definitely wrong." And you provided it! 🙂
thanks,
ron
February 3, 2014 at 10:43 am
I figured a half-hour of research on this question was more than enough. I accept my fail. At least I didn't cheat! 😀
And since I've never reset an...
January 3, 2014 at 6:27 am
You didn't say it had to be complicated, so...
SELECT ROW_NUMBER() OVER (PARTITION BY x ORDER BY y) AS RowNum, x, y
FROM tTable
ORDER BY RowNum;
ron
December 5, 2013 at 8:36 am
Luis Cazares (12/2/2013)
The combination of the columns should be unique as i is an identity column and will generate different values each time.
Blast it, I read this whole thing wrong....
December 2, 2013 at 7:14 am
Viewing 15 posts - 16 through 30 (of 191 total)