Grant Fritchey (11/9/2009)

---

I realize I'm not terribly well educated... but I didn't recognize a single name on that list. I must not know what I'm doing. I'd better go tell...

No sledgehammer, I need this modem....

TheSQLGuru (11/10/2009)

---

1)

That is incorrect. While you cannot do an index SEEK, a query...

Likewise. We must do this more often.

Tell me about it. That last flight...

What's log_reuse_wait_desc? I don't offhand know the codes.

And an occasional index rebuild, doing all the indexes or targeted to the...

One of your processes is indeed using serialisable, at least according to the deadlock graph, and in a user-started transaction. If the proc's not setting it, maybe it's the ADO...

John Mitchell-245523 (11/10/2009)

---

Looking at it rationally rather than empirically, I'd say that since a log file is written to sequentially, any activity (such as truncation) that moves the disk heads...

Sorry. Will be leaving now. (cause battery's low and ADSL still needs configuring. maybe a Hammer will help......)

Are you using serialisable isolation level? If so, why?

Please take a read through this: http://www.sqlservercentral.com/articles/64582/

You can index it, but it's completely useless to do so. It's not possible to encrypt a parameter and compare to the stored encrypted value as the encryption routines are...

in addition, SQL Enterprise edition is only supported on server operating systems. Windows 7 is a client machine OS.

talltop-969015 (11/9/2009)

---

I am still not exactly sure why the shrink does this, but what is important is to realize here is that it DOES, and to be mindful of...

There's still a database referencing those files. Query sys.master_files, see which db is referring to those files, then drop that database.