Featured Article(s)
Troubleshooting error 18456 in SQL Server 2005
In this article, Alexander Chigrik explains how you can troubleshoot error 18456 in SQL Server 2005.
Webcast Today – Register Now
Visual Studio 2008 Quick Tips
In this presentation you’ll see a series of tips for making your time spent in Microsoft Visual Studio more productive. Presented by: Rachel Appel
> Register Now
> 9/23/2009 at 12:00pm Noon Pacific
Guest Editorial – Chris Shaw, SSWUG Site Manager
Are you using the Maintenance Plans for your database maintenance?
The good news is, if your jobs are completing without error then you should have a backup that you can restore to. However, one thing you may want to consider is you could be indexing tables that you don’t need to.
The other day I was looking for a script on SSWUG and I found a script written by Ola Hallengren, this script will remove fragmentation based on the information from the dynamic management view sys.dm_db_index_physical_stats.
When you rebuild indexes based on the fragmentation rather than doing them all at one time, you can save on a lot of processing and shrink your maintenance window. Check out Ola’s script here:
http://bitonthewire.wpengine.com/scripts/viewscript.aspx?id=762
This is one of many scripts that are located in the database we encourage you to upload your scripts and share them with everyone in the community.
Why re-invent the wheel if we don’t need to? You can see the other scripts that we have online here:
http://bitonthewire.wpengine.com/scripts/
Featured White Paper(s)
Developing Something for Nothing with SQL Server: A Closer Look at SQL Server Express and How it Can Work for You
Software development is an expensive and time-consuming process, not just in terms of time and salaries but also in terms of … (read more)