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 see my previous blog http://blogs.msdn.com/cindygross/archive/2009/11/20/sql-server-and-fragmentation.aspx. — Cindy Gross 2009 — find fragmentation on all indexes inContinue reading “How to Find the Amount of Fragmentation on Your SQL Server Instance”
Tag Archives: sql server 2005
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 a pre-conference talk at SQL PASS next week. The preContinue reading “How People Abuse Their SQL Server Transaction Log – Things NOT to Do”
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. 3) For Windows 2008: Validate the configuration using “Validate a Configuration” in Failover ClusterContinue reading “Checklist for installing SQL Server 2005 as a clustered instance”
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 but will also apply to SQL Server 2008. · I would hesitate to grant anyContinue reading “SQL Server Security Granularity”
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 2005 Practical Troubleshooting: The Database Engine — Handy cluster related infoContinue reading “SQL Server 2005 Clustering Tips/References”