Thanks for the easy one!

I had also written about this in one of my older posts at http://beyondrelational.com/modules/2/blogs/77/posts/11389/sql-server-experiments-with-bit-data-type-is-it-really-boolean-can-values-other-than-0-and-1-be-assi.aspx - The world is round!

Have a good week-end!

I choose option #1 myself and ended up with a lost point. A refund, please 🙂

Great question! Forces one to read the documentation before answering. Trick to the answer really lies in both - the behaviour of the RAND() function and the UNION operator.

Thanks for...

Like it, got it wrong, and learnt about the syntax (i.e. the "ADD" keyword).

However, dropping and recreating works just as well (and was the only option I knew about till...

Agree with the posts above. It's the "outer" query that determines the execution of the "inner" query.

The TechNet Link shared (http://technet.microsoft.com/en-us/library/ms187638%28v=sql.105%29.aspx) has sufficient proof for "D" to be the right...

I got it wrong, but the "correct" answers stumped me. How are "local" temporary tables visible across sessions?

I agree with the suggestion to add a filter in the UPDATE statement if that is feasible.

The thing is that although it looks like nothing has been updated, 2 records...

Just thinking out loud (not prototyped/tested) - is it possible that both servers have different hard drive partition configuration when they were formatted as part of setting up of the...

The surest way of validating the syntax is always running it on a test server. NOEXEC and other alternatives will not be able to catch all syntax exceptions.

Agree with the other responses. Also, if you are using table variables, you do not need to drop and recreate them. They will be destroyed once the stored procedure completes...

It is wierd. This is just a guess - Could it be that the recovery model may be changing which is causing the log to flush over to the data...

Got 4/5 right, but am slightly disturbed by the question, primarily for the following reason:

The "disallow results from triggers" Server Configuration option has always been 0 by default in all...

I am currently supporting 7 developers (one of whom works from a remote location). However, we have seen periods where we had 2 DBAs supporting about 24 developers (making for...

If you are using SQL Server 2008 R2 and below, you can use FMTONLY. For SQL Server 2012 and above, you can use sp_describe_first_result_set.

Read more about it in my post:...

Assuming that the first value in the table gives me the ladder increment, does this work for you?

USE tempdb ;

GO

DECLARE @ladderTable TABLE ( Col1 INT ) ;

DECLARE @incrementValue INT =...