Cindy Gross: SQL Server + Big Data

Cindy Gross - SQL Server and Big Data Troubleshooting + Tips

Browse by Tags

Tagged Content List
  • Blog Post: 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 see my previous blog
  • Blog Post: SQL Server and Fragmentation

    There are several types of fragmentation that affect SQL Server, all of which have the potential to cause performance problems. 1) At the disk/OS level individual files can become fragmented due to growth over time. This can be addressed by a defragmentation tool at the SAN or Windows level. Ask your...
Page 1 of 1 (2 items)