This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
SQL SERVER – Measure Index Performance
My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
SQL SERVER – Execution Time of Stored Procedures
How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.
SQL SERVER – sp_updatestats Performance and Disabled Nonclustered Indexes
Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.
SQL SERVER – JOIN Elimination for Not Selected Column
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
SQL SERVER – Disable Statistics Update for a Single Table
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?