User Id:
Forgot User ID or Password?
Facebook Twitter Linked In Stumble Upon Digg In
Desktop Development(3)
Development Lifecycle(2)
Dot Net Nuke(1)
Enterprise Systems(1)
Frameworks & Libraries(0)
General Programming(25)
General Reading(6)
Graphics / Design(10)
Mentor Resources(0)
Mobile Development(3)
Research Papers(1)
Social Media(1)
Software Engineering(3)
Third Party Products(0)
Web Development(11)
Add a Article

Re-Indexing all tables of a Database

Re-Indexing all tables of database

/**************************************/ /* Name: Re-Index all tables in a Database using only one statement */ /* By: Faheem Habib */ /* Side Effects:ALL indexes in all user tables rebuilt to servers default fill factor value*/ /**************************************/ To re-index all table of your database, please execute the below code in your SQL Query by selecting your database.

Exec sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")'

Average: 5.0000, Total Ratings: 1


FAQ Messages  newPost a Message 
There is no message currently

Last Updated July 21, 2019 | Advertise | Privacy Policy
Copyright © QAU Programmers, 1999-2019 All Rights Reserved. Terms of Use