User Id:
Password:
Forgot User ID or Password?
     
 
Facebook Twitter Linked In Stumble Upon Digg In
Articles
Database(11)
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)
Languages(2)
Mentor Resources(0)
Mobile Development(3)
Multimedia(0)
Research Papers(1)
Social Media(1)
Software Engineering(3)
Third Party Products(0)
Web Development(11)
Add a Article
 
Articles

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 November 19, 2018 | Advertise | Privacy Policy
Copyright © QAU Programmers, 1999-2018 All Rights Reserved. Terms of Use