A clustered index contains every single column in the table in it's leaf level. Hence it is covering for any query.

Be patient a bit please, I want to get a second opinion here.

I strongly suggest that you restore MSDB from backup. You've got some nasty corruption there and repairing the system databases is not generally recommended.

Restoring MSDB isn't the same as for...

Good. So what's the output from CheckDB?

Just to check, you do have backups of MSDB? You have been backing up the system databases?

MSDBData is the name of the file, not the name of the database. If you query sys.databases, you'll see that database 4 (ID given in the error message) is called...

Please run the following and post the full and complete output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Depending how bad this is, it may be necessary to restore from backups. Do...

Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several...

lmu92 (2/26/2010)

---

Kit G (2/26/2010)

---

Hey! You got it! Glad I could help out with your understanding of Cloud Computing. One other thing I should mention, the temperature of...

Any other messages?

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Could be just about anything anything in the IO stack

Misbehaving filter driver (eg anti-virus)

Buggy HBA drivers

Faulty fibre switch

Problematic SAN controller

Glitch in SAN's write cache

Failing drives

etc

GSquared (2/26/2010)

---

This kind of design can be done efficiently if you have the front end generate a GUID, instead of using a database-generated integer ID. The GUID can then...

allan.kendall (2/26/2010)

---

I have had it suggested to me that I should/could use a transaction to carry this out. The transaction would submit the user form data first, then get the...

Not a good design.

The only way to ensure no duplicates and no blanks would be to hold an open transaction, locking enough rows that an incorrect id can't be inserted,...