Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
defraging sql database
Hi jay, thanks for the reply,you where right about the difference between INDEXDEFRAG and DBREINDEX but my question is how to make it work using the query analyzer,because when i type the DBCC SHOWCONTIG the letters are all blue and you can excute the command,but when i type DBCC...- v555
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
defraging sql database
please can anybody help me with this problem,our datadase is fragermented to nearly 80 and i have tried using the dbcc indexdefrag and eachtime i tried i get the following error."an in correct number of parameters where giving to the DBCC statement".or can you send the script on how to defrag...- v555
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Setup and Administration
