Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql server 2005   (RSS)
Thursday, January 07, 2010 3:40 PM

How to Find the Amount of Fragmentation on Your SQL Server Instance

Need to find the amount of fragmentation in all your indexes in all databases for a given instance of SQL Server 2005 or later? You can use the undocumented/unsupported sp_MSforeachdb to loop through all the databases. For more information on fragmentation
Posted by CindyGross | 0 Comments
Wednesday, October 28, 2009 2:47 PM

How People Abuse Their SQL Server Transaction Log - Things NOT to Do

Care and Feeding of the Transaction Log Want to learn more about how the transaction log works? Kalen Delaney, celebrated author of SQL Server 2008 Internals and the Inside SQL Server series as well as a world class trainer and performance tuner, is giving
Posted by CindyGross | 0 Comments
Friday, October 23, 2009 4:06 PM

Checklist for installing SQL Server 2005 as a clustered instance

Checklist for installing SQL Server 2005 as a clustered instance Windows/Hardware 1) Verify the Windows cluster is set up per basic best practices and that basic failover works. 2) Verify you have the latest patches, especially security patches, for Windows.
Posted by CindyGross | 0 Comments
Wednesday, September 02, 2009 5:10 PM

SQL Server Security Granularity

I have had some questions recently about how to grant developers certain permissions without giving them sysadmin rights. Hopefully this summary will help you determine how to grant the least possible privileges. The summary is based on SQL Server 2005
Posted by CindyGross | 0 Comments
Wednesday, June 10, 2009 12:54 PM

SQL Server 2005 Clustering Tips/References

I have copied this over from an older blog . I have cleaned it up a bit to clarify a few areas and added some links. SQL Server 2005 Clustering Tips/References This information will supplement the clustering information I wrote in chapter 10 of SQL Server
Posted by CindyGross | 0 Comments
 
Page view tracker