Trooper09 (11/12/2009)

---

The column avg_fragmentation seems to have pretty high values on few of the indexes on the databases more than 80 and I beleive I should be rebuilding the indexes...

Try RESTORE DATABASE <DB Name> WITH RECOVERY

A clustered index can't have include columns, just specify the key

I can try...

The output of @@Versions confuses so many people. The different colours show what's referring to what.

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)

Dec 16 2008 19:46:53

Copyright (c)...

Those numbers are cumulative. They show the total cpu and the total IOs that the connection has done since connecting. If these connections have been open for a long time...

That's an incredibly wide index. What about dropping that and creating a clustered index on

Company_No], [Year_For_Period], [Period]

It's a bit wider than I like for a cluster, but it may...

Sure that's the right execution plan? It shows only a conditional drop object.

If I'm not mistaken, it gets the info from the session DMV, and that's cumulative since the connection first connected. Sleeping means not currently running anything.

No. The SQL server error log. SQL Agent has nothing to do with anything here.

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

Gutter.

Technically, it's not a bug. It's a...

Where are you seeing those values?

Esalter (11/12/2009)

---

Presumably SS like most all other DBMS's makes use of a compound key index to search a table when a query is searching on columns that form the major...

If the table is a heap. Indexes...