Tag Archives: performance tuning

SQL Server Health Check HTML Report

Posted on May 9, 2020 by uday arumilli

SQL Server Health Check HTML Report is useful to quickly get the performance snapshot of a database instance. After going through the overall system parameters, except the minor issues we can clearly state that the both instances are optimally performing. Index maintenance and the database log file maintenance are the critical activities to be considered. Please make note that the HC report tool is not reporting the SQL code issues and its scope is restricted to the database system level performance. Continue reading →

Posted in Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , | 49 Comments

Filtered Index on NULL values is still doing a Key Lookup

Posted on September 8, 2019 by uday arumilli

“Filtered index” is really useful when you want to customize and narrow down the data usage and it works like a magic with the minimized index maintenance cost.
When you are creating a filtered index on IS NULL condition, be aware that we need to include the same column. Continue reading →

Posted in Performance Tuning, SQL Development | Tagged , | 3 Comments

SQL DBA Interview Preparation

Posted on July 12, 2017 by uday arumilli

 SQL DBA Interview Preparation This post can help you in SQL DBA Interview Preparation. We blogged various pages and posts and SQL Server DBA Interview Preparation, this post is helpful to locate / link all the content that is useful … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , | 9 Comments