When you use the Wizard, have a look at the SQL code it creates ('Script Actions to a New Query Window'), and you'll see that it specifies the file sizes...

Babylon 5 or nothing.

http://xkcd.com/1166/

They have no idea what a never-ending thread really is...

I got this question right, but only because there isn't enough information to make an choice about one over the other.

The true answer should be "Either is a candidate at...

Any Log activity while the backup executes is also backed up. This effectively means that when you restore the backup the log might be rolled forward, processing these transactions.

SELECT INTO creates the target table, and the only exception along the lines that you are after is with the IDENTITY column.

You could leave the Rowversion column out, as already...

I have frequently had to script out Stored Procs that use dynamic SQL, and the joys of altering the number of quotes defies description.

Using the 'Generate Scripts' option within SSMS...

CU5 is available - http://support.microsoft.com/kb/2777772

The best resource is actually here, on SSC: http://www.sqlservercentral.com/articles/trace+flags/70131/. Otherwise you end up hunting in several areas to gather a comprehensive list.

In the dynamic query you are actually joining three string of character together and then using the EXEC command, which is designed to execute a command stored within a string...

Because the first query is running:

IN (1,2,3)

and the second query is running:

IN(@SampleArray)

which is the equivalent of IN('1,2,3') because it is a varchar. Please note the '' characters around the numbers.

SQL...

What split function are you referring to? Is it this - http://www.sqlservercentral.com/articles/Tally+Table/72993/ ?

In the first query, print @SQL1 after the execution and have a look at what code that is actually running, then you'll see the difference between the two queries.

Indeed it does.

There are many paths to becoming a DBA and you see several of these routes when reading SSC regularly, so don't worry that your path might not be 'correct'.

Over the...