Yes it will. The where clause must consist of conditions, where one expression is compared against another. As I said in...

The only way to do that is to use dynamic SQL, build up the final query and then use sp_executeSQL to run it.

Be aware of the downsides of dynamic SQL...

Does the directory 'R:\MSSQL\BACKUP' exist?

Is there anything more useful in the SQL error log

Why 5? What's magic about a 5 table...

Spid 90 wasn't even involved. The deadlock...

GSquared (12/5/2008)

---

Replace all the Or and In statements with Union queries and the whole thing will probably speed up. Depends on your indexes, of course, but it can make...

Tables, indexes and execution plan please.

For the exec plan, right click on the plan (in management studio) select save as. Save it as a .sqlplan file. Zip that file and...

Don't change the where clause. You don't want to change what rows the query's returning (affected by the where clause), you want to change how the results are displayed (the...

Depends on the table, depends on the query, depends on the index.

e.g if the table has say 100 rows will it still use table scans despite there being indexes present...

I'm going to guess that the columns are varchar and there's an index on at least one of them. If you compare a varchar column to an nvarchar parameter, SQL...

I'm not even sure you can.

Maybe for a static reporting environment where all databases are static, but that's an odd case. SQL just doesn't scale out.

Yes, but it's not the same databases.

Active/active is two instances of SQL each with their own databases, one running on each node (hence each node is active) and set...

juancabrer (12/5/2008)

---

3. Open the transaction log that took place after data corruption took place, delete the transactions that corrupted the data, save the transaction log, and apply this new saved...

There's no way to have two active instances of SQL on two machines using the same database files (as you would have in a load balancing scenario). The way clustering...

Where are you going to put your backups?