Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server.
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers