You cannot have two clustered indexes.

Can you post the queries that you're having performance problems with and their execution plans as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Looking at the indexes, they're a little weird.

The...

Firstly why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

Shrinking causes massive fragmentation and will just result in...

Please also note that DBCC DBREINDEX is deprecated, should not be used in new development and will be removed in a future version of SQL. The replacement is ALTER INDEX...

Eswin (12/19/2009)

I used DBCC CHECKDB WITH ESTIMATEONLY

and found that around 2Gb tempdb space needed to run DBCC CHECKDB.

Then i performed DBCC CHECKDB WITH PHYSICAL_ONLY on that 300GB DB....

Yes, they are. But that's database version, not compatibility level.

A database on a SQL 2008 server is a SQL 2008 database with the SQL 2008-style statistics, the SQL 2008...

Absolutely none. You can change compatibility level as often as you...

Since the data will be stored for posterity, I'm going to suggest a full, normalised database design, tables that store information about single 'things', foreign key relationships, the works. Yes,...

Witching hour being the middle of my morning. I find that the...

Yeah, that's what I said. Replace the <Database Name> with the actual name of the database (in this case Sharepoint_Config)

So it looks like a transient IO failure. I would recommend doing lots of diagnostics on that drive, or even just consider replacing it. Intermittent IO failures are not pleasant.

Please...

I'm trying to figure out if there's a better database design here, something other than EAV or 3000 columns in a table. On order to do that, I need to...

Those messages show restart-recovery. They occur whenever a database is opened. If you're seeing them often in the logs it means that the db is set to auto_close or it's...

Please tell me that you have a backup of this database.

Is that all of the errors in the error log?

Can you check the windows event log for any disk-related...

Grant Fritchey (12/18/2009)

Yes & no. How...

Can you post the revised exec plan? I want to see if there are indexing opportunities.

Just a word of warning. Scalar functions like the one that you have there are...