The index that you have there is completely useless for seeks. The leading column is not used in the where clause at all. That query will execute with an index...

tsd_suresh (11/12/2009)

---

I am trying to restore DB with no recovery model for Log shipping. while i try to restore from backup with No recovery model . ...

TheSQLGuru (11/11/2009)

---

You made a very important piece of information public there: GL transactions. In my experience with financial data GL rows are almost never updated/deleted. That means...

Why does DTA recommend them or why does auto_create never create them?

For the first, I don't know. Personally...

hlam-1032421 (11/11/2009)

---

With comments like this I run for the exit:

… good clustering. One school says to put the clustered index on the column or set of columns that would be...

But the combination...

Traceflags change some piece of behaviour of the database engine. No idea what 8107 does, can't seem to find any info on it. Have asked some friends.

You'll probably find this...

There's also one on Michelle's blog - http://www.sqlfool.com

A syntax check would have shown it...

What's the error?

The queries that, when they are run, show wait times with the async network io wait type. Query sys.dm_exec_requests to get a snapshot of what's happening. Do that repeatedly at...

Ok, now I'm really confused. If you're doing sums later, surely you need all the rows? If not, which of the 'duplicate' rows do you want to keep and which...

It refers to the width of the column, ie the number of bytes it takes....

There are two rows with ClientNumber, ClientAccNumber 6035BD,101422296. What determines which of the rows you want in the output?

Attach them. Look up CREATE DATABASE ... FOR ATTACH in Books Online. It's not always possible to attach the files, especially if the DB was no online or the database...