Category: Performance Tuning

  • SSRS: Parse parameters column from ExecutionLog

    Ever worked on a quick little project, come across what you assume is a common need and think “I’ll just google up some code that someone else has written and then be off to the races”?  Have you done this and not been able to find the code you’re looking for? Well, that was me […]

  • Add Page Compression To Every Table In Your SQL Database The Winston Wolf Way

    So you need to add page level compression to every table in your SQL Server database? I’m not going to judge you. I’m not going to tell you it’s a good idea or a bad idea. I needed to do it in my DEV environment and maybe you need to do it in your production […]

  • Parse and sort SET STATISTICS IO output with Excel

    I wish I could say this was my idea. Somebody posted it on twitter awhile back and I did the classic “facepalm”. I have no idea how many times I manually picked apart the results of SQL Server’s SET STATISTICS IO ON without considering creating a formula to handle it for me. So, somebody came […]

  • Clearing the SQL Server Analysis Services Cache

    Preparing to do some MDX performance testing?  Step one for each and every test should be to clear the cache.  This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory.  How do you empty the MS SQL Analysis Services cache prior to running your query?

  • SQL Server Partition Lock Escalation Property Query

    Whenever I want to check a setting in SQL Server I always prefer to find it using a query.  Every once in awhile these settings turn out to be on the verge of being undocumented.  This is the case with table level lock escalation (also known as partition level lock escalation).  The T-SQL query below […]

  • Find User’s Default Schema

    Need to find the default schema for a user in MS SQL?  Need to confirm all your SQL Server users default schema’s are set correctly?  Easy peasey.  Run the following query and enjoy.

  • Find Tables Without Clustered Indexes

    Need a way to find all tables without a clustered index in SQL Server? Running this script every once in awhile will help ensure best practices are being followed and every table has a clustered index. This script is compatible with SQL Server 2005 and SQL Server 2008.

  • SQL Server Rebuild Indexes – The Fastest Way

    Want to rebuild all the indexes in your MS SQL database?  The script below will rebuild all the indexes in your SQL Server 2008 or SQL Server 2005 (SP2) database and offers a number of enhancements that make this the best SQL Server index rebuild script in all the land and the first choice of […]

  • SQL Server Update Stats – The Fastest Way (with FULLSCAN)

    The following script is the fastest way to update stats on all your tables with the FULLSCAN option. Developed and tested by SQL Server Consultants.