Missing indexes is a suggestion, nothing more. The entries in there are created by the query optimiser as it optimises a single query. They may be correct, they may be...

My gut feel is that this database is unrepairable.

There's corruption in one of the system tables (syscomments) and that kind of damage CheckDB is not allowed to repair. In...

Thanks.

Was there another line at the bottome, something like "minimum level to repair this error is..."?

Ok, clarification time. The first check going to Master was true for 2000 and below. In 2005, it's a little more complex, but the same general idea.

When you execute...

David Reed (8/14/2008)

---

My wife and I met on the sparring mat in a college ROTC unarmed combat course; she broke my nose and I knew that she was the...

Paul Timmerman (8/14/2008)

---

1. I am using sys.dm_db_index_physical_stats. How exactly is this data kept current? It is very convenient to have this is handy management view, but I...

Mark Beringer (8/14/2008)

---

The tables has about 40 Columns, I have 14 reports that all expect the 3 WHERE clause conditions, the only difference are the columns that are returned, so...

Usually that's because some other resource is a bottleneck. It's fairly hard on modern servers to max out a lot of CPUs for long periods due to the much slower...

Won't help. SQL does not use one CPU per datafile or anything like that. Decisions around splitting data files should be based on IO load. Secondary log files are usually...

Paresh Randeria (8/14/2008)

---

"When you call a stored procedure that starts with sp_, SQL Server always checks the master database first, even if the stored procedure is qualified with the database...

I prefer bokken, with jo staff a close second. Never tried a bo, it looks difficult.

I tried Kendo...

Please do. I would like to see just the informational output without any comments on repair.

jigo0624 (8/14/2008)

---

We have a system where the log file got full. By accident (or not) the log file was deleted. I tried attaching the mdf file but it...

sunshine (8/14/2008)

---

No good backup, this db has been corrupt for quite some time, i'm trying to fix what i can with what i have.

this is the output with no...

In dev and test, I would say yes. It helps a lot in testing and...