Forum Replies Created

Viewing 15 posts - 16 through 30 (of 191 total)

  • RE: IN or OR

    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...

  • RE: IN or OR

    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...

  • RE: In-line variable assignment 1

    Apparently, while variable declaration occurs at compile time, inline assignment does not. Good to know.

    ron

  • RE: IDENTITY_INSERT problem (doing something stupid?)

    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...

  • RE: IDENTITY_INSERT problem (doing something stupid?)

    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...

  • RE: T-SQL SELECT..INTO

    Stewart "Arturius" Campbell (3/11/2014)


    ronmoses (3/11/2014)


    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...

  • RE: T-SQL SELECT..INTO

    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...

  • RE: REPLACE behavior

    Richard Warr (3/6/2014)


    It's anything but logical behaviour and you can only get the question correct if you know that caveat on the REPLACE function (or if you just run the...

  • RE: Database creation takes a long time...?

    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

  • RE: Database creation takes a long time...?

    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...

  • RE: Database creation takes a long time...?

    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...

  • RE: Database creation takes a long time...?

    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

  • RE: DBCC CHECKIDENT

    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...

  • RE: SQLServerCentral apologizes and you can win a book

    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

  • RE: Order My Data

    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....

Viewing 15 posts - 16 through 30 (of 191 total)