Since you're using SQL 2005 (or I assume you are, since this is posted in the SQL 2005 forums), use sys.databases instead. The statuses are neatly broken down in a...

Transactional replication does not depend on recovery model. http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/

What issues did you...

Jack Corbett (11/18/2009)

---

Well then ask some questions. What are you confused about? I'm sure Gail, the author, will try to clarify,...

A clustered index scan is a table scan, so that's usually a bad thing.

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Cliff Jones (11/18/2009)

---

The Tuning Adviser often recommends that a column which is also a part of the Clustered index be added as an included column. I do not do...

Indeed. Who creates a database without checking to see if the drive they want to create it on really exists?

1) Probably.

2) Still don't understand what you're asking. When a transaction occurs, all necessary changes are made in memory. When the transaction is completed, the changes are hardened into the...

sjsubscribe (11/18/2009)

---

Say I have a non-unique, non-clustered index with some included columns. It covers a bunch of frequently used queries. I could make it an unique index if I add...

How many rows returned? What's...

Indeed. Order for included...

Yes, but would still like table definitions, index definitions and the query that we're trying to help you with.

The problem is, without seeing the cursor definition and how the inserts and deletes relate to the cursor, it's hard to say anything useful. A simple insert and delete in...

Nope. Bit far to travel and I've already done Seattle this year. Enough travelling for a few months.

The first thing you need to ask is whether the poor performance is normal or abnormal. Is the system always slow or is it usually fast, but has been slow...