Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes | RSS News Feed
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes - Latest News
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
This is the first article in what I hope will be a series on leveraging the rich and varied metadata available to us in SQL Server for automating common operations. There are times when working with data in SQL Server when temporarily disabling indexes can ... read more
HP TouchPad Needs 6 to 8 Weeks for Additional Shipments
HP needs 6-8 weeks to ship additional TouchPads, according to a leaked email sent to customers. HP is prepping one last run for its defunct tablet. Hewlett-Packard will apparently need close to two months to start fulfilling backorders for the (temporarily ... read more
Why Are You Dropping and Recreating Your Indexes?
By disabling an index, you have basically turned off the index, but have allowed SQL Server to retain the index definition in the database metadata. If you want the index back all you need to do is rebuild the index. If you drop the index, SQL Server no ... read more