Please read the article I linked.

I don't want to guess as to your requirements and I would like to be able to test it before posting. Hence the request...

Regarding the fragment size, larger is better. The ideal is that fragment size = number of pages in index. Generally,...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Of course. No point in rebuilding an index that isn't fragmented.

Don't panic 😉 http://www.sqlservercentral.com/articles/65804/

On SQL 2000 run DBCC UPDATEUSAGE and check again. There were 'inadequacies' in the way SQL 2000 maintained the space-used metadata in the database.

Don't worry about fragmentation on tables that small. Fragmentation's only...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic677775-146-1.aspx

If you have a backup, restore from backup. It's when you don't have a backup that all sorts of tricks are needed to get the DB back.

Why don't you buy the training kit? It's well worth the money spent.

Depends what type of index. If it's the clustered index that...

gdavidson (3/17/2009)

---

set @CRno = (SELECT IEIncidentID FROM inserted)

set @EventID = (SELECT...

Cannot run out of time. There is infinite time. You are finite, Zathras is finite. This is wrong tool.

Jack Corbett (3/17/2009)

---

GilaMonster (3/17/2009)

---

Bob Hovious (3/17/2009)

---

I'm still hoping to one day find sp_MSGoBackInTime documented in BOL. It is THE essential tool for recovering your database when you never...

Chris Morris (3/17/2009)

---

There seems to be an inverse square law operating between the amount of time and effort you put into a post, and the chance of the OP responding...