The answer "Remove the TOP and WITH CHECK options" is also correct as insert will work when both TOP and WITH CHECK removed. So, this question should have three correct...

Sorry, but this script won't work well for large tables, especially with heavy use of IN() and NOT IN() operators.

MERGE is usually faster than series of consecutive INSERT/UPDATE/DELETE statements.

Unfortunately, the correct answer is not in the list: Turn the source database into a read only mode before running a tail-log backup

Thank you Daniel for a very good feature comparison. Although, I agree with the reasoning and comparison, I cannot agree with the outcome. For me as a DBA, SSMS is...

For me it looks like a bug when driver converts parameter types like this.

Sergiy, below is what happens when parameter passed as variable

Here is the query:

And here how it is actually executed on remote server:

Please note that...

Thank you ScottPletcher, your method worked. The query was executed on remote server "as is". The only downside of this method is inability to use parameters. However, this is better...

Here is a sample query executed on a SQL Server:

This is how this query get actually executed on a remote server (caught by SQL Profiler). Please note...

It's varchar on both ends. However, collations are different. One on remote server is CS while local CI.

• This reply was modified 3 years, 7 months ago by  andrei_solntsev.

You right, but it's absolutely wrong. Must be considered as a bug

Nice question!

Try this: SELECT 9test, 1prod;

which is equivalent to

SELECT 9 test, 1 prod;

SELECT 9 AS test, 1 AS prod;

Looks like when name starts with number, SQL interprets it as a...

Not exactly correct question. The right answer depends on assumption. We do not need to guess if other permissions were given to use or not. The question should state that

That's ok. It is possible to rewrite code to use different rules.

For example, you may define Ship_Definitions table as

IF OBJECT_ID (N'tempdb.dbo.#temp_Ship_Definitions', N'U') IS NULL

BEGIN

CREATE TABLE dbo.#temp_Ship_Definitions

(

...

Hi Sean,

Great program, I had a lot of fun playing and analyzing it.

The only problem I found is that ship placement is not random enough which makes it easy to...

Why don't use old and reliable bcp utility?

You can export your table into file by something like

bcp Table out FileName.dat -S server -d database -n -T

and then import it back...