Agreed. The "ensure" would dictate at all times which would be inclusive of anyone creating an index. There is no way to "ensure" the omission of the compression parameter for...

Great script, thank you! I think you meant for this line:

RIGHT(FileName,CHARINDEX('',REVERSE(FileName))-1) PhysFileName

to be

RIGHT(FileName,CHARINDEX('\',REVERSE(FileName))-1) PhysFileName?

How is the correct answer correct? Am I missing something? The correct answer is item #1 and it's being marked incorrect. ???

When I run the query on my Azure server...

What they said ^

So, =0 would also be correct, right? SELECT DATEDIFF(SECOND, '12:00 AM', '12:00 AM') = 0 = New Year. 🙂

Answer A is the correct answer. Conversion of data to a type means it became that type.

Item 4 was my choice, which IS correct whether you think so or not, and the best way to perform this operation. Why would you consider this incorrect? It is the...

This really should include the WITH COPY_ONLY in the command. Not using this breaks your backup chain.

Order By Movie will also provide the correct answer, yet it tells me I'm incorrect?....:Whistling:

How is this any better than renaming the tables with sp_rename?

Not a fan of trick questions.

Another question with an incorrect "correct answer". Having is after group by my friend. I want my point! 😀