Perform Reindexing For Defragmentation

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Perform Reindexing For Defragmentation

Author

Topic

rebelk0de
Starting Member

4 Posts

Posted - 2009-02-23 : 12:27:28

Hi everyone,

Its been a long while since I last login. Anyways, I have been given a task by my manager. He has asked me to perform "reindexing for a sql server 2005 db that is more than 70% defragmented". He told me to do so, without causing the server to hang since its a production server for a MNC. The method he has instructed me to use is the ALTER.INDEX.

I'm new in reindexing and defragmentation. Can someone please help me out. I need to get this done ASAP, and I'm getting very worried.

Here are some details. Im not sure if its helpful, but here it is:

Server OS: Windows Server 2003 R2 SP2
SQL Server: Microsoft SQL Server 2005
Method to be used: ALTER.INDEX

Thanks Guys for the help. Cheers!

--
http://blog.slickw0rm.net

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-23 : 12:47:01

Then you can use ONLINE INDEXING.Remember Online indexing can take huge Tempdb space if (Sort in TempDB = ON). Check for Tara's Script for it.