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 – Script to List Database File Latency
Today, we will see a very interesting script to list database file latency. I use this script quite often in my Performance Health Check.
SQL SERVER 2022 Features for Performance Optimization
I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.
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 – List of Trace Events
I posted a blog post SQL SERVER – Identify Table Creation Date from Traces. Let us see how to see all the list of trace events.
Snowflake – Analysis Query Performance
I am doing consulting Snowflake Comprehensive Database Performance Health Check, who recently asked me if I know any way to Analysis Query Performance.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.