It's a parse-time error. The *entire* batch gets parsed and bound before any part of it gets executed. The parser cannot execute code. Hence the error is thrown.

Oh, and the...

Nope. You can join as many tables as the resources on your server (memory most likely) allow. The...

Wait, wait, wait, what????

WHERE (1 = 1 OR EXISTS (SELECT * FROM AB WHERE AB.Customer_A_Id = A.A_Id AND (AB.Number LIKE @T AND 1=1)))

1=1 is always TRUE.

TRUE OR <anything> is TRUE....

(2) probably won't help. 50 is already high.

(1) might help, but probably not all that much. With 16 cores, probably 8 is a decent starting point, but don't expect it...

I would say no.

Logical fragmentation affects the performance of large range scans from disk. Emphasis Large and Disk.

An insert is not going to require that SQL do a large range...

No.

If you want something like that, you'll have to either set up a trace that logs stored procedure execution, or add code to each stored proc that logs its execution...

Not unless there's free resources on the host. If your host has...

Steve Jones - SSC Editor (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did it...

Table definitions and sample data please.

Automate it.

You shouldn't be doing it. The junior shouldn't be doing it. A job should be restoring each backup to a test server,...

COUNT(<any constant>) means count the rows in the resultset. If you say COUNT(<any constant>) FROM Table, then it returns count of the rows in the table.

Sure, with the same general idea.

t1 INNER JOIN t2 on t1.Col1 = t2.Col2 OR t1.Col1 = t2.Col3 OR t1.Col1 = T2.Col4

Don't know what the performance will be, but I can't...

Hugo already explained.

So if any tables are involved (I assume...

Please note: 4 year old thread.

Question: Dropping any index on the table, whether it is used by the query plan or not.

MSDN: Dropping an index used by the execution plan.

Dropping any index on the table...