Forum Replies Created

Viewing 15 posts - 451 through 465 (of 848 total)

  • RE: Order of Execution

    Nice question, thanks.

  • RE: Snapshots

    Learned something new, thanks for the question!

  • RE: DBCC CHECKDB WITH TRY/CATCH

    Nice question, learned something today.

  • RE: XML index

    Nice question, thanks!

  • RE: Cast in Varchar with different options

    Nice question for a Monday. We've had ones like this recently enough that I would have expected the percent of correct answers to be closer to 100%. Maybe we have...

  • RE: Max processor cores

    Lynn Pettis (7/12/2012)


    Although I got it correct, I think the true correct answer should have been Operating System Maximium. This would have taken the version of the OS out...

  • RE: Database

    I was looking for a trick in this question too. But after re-reading the answer choices multiple times, I just went with what I thought was the obvious answer and...

  • RE: String Length

    IowaDave (7/11/2012)


    Why does datalength of nchar(40) give 80?!?? That really threw me.

    Thanks!

    Because it is the entire length of the string * 2 bytes. Nchar includes padding so the length...

  • RE: T SQL

    Thanks for the question. I thought, surely they wouldn't add a where clause to truncate. I didn't see how they could.

  • RE: Index Types

    Sean Lange (7/6/2012)


    mtassin (7/6/2012)


    Sean Lange (7/6/2012)


    KWymore (7/6/2012)


    Points back, Steve?

    I think you just figured how to get them back yourself. 😉

    Nah that gets you a point post... if you look at...

  • RE: Execs and temporary tables

    Nice question to end the week on. Thanks!

  • RE: Index Types

    Points back, Steve?

  • RE: Index Types

    I am all for multiple choice questions and do not necessarily need a hint to pick 2 or pick 3 but as someone mentioned before, a count cannot be more...

  • RE: Transaction

    Nice question on transaction behavior. Thanks!

  • RE: Views and changes

    Thanks for the easy one Steve! I think I have used this command maybe once before.

Viewing 15 posts - 451 through 465 (of 848 total)