Question: How to Measure Page Splits Counter Value via T-SQL?
SQL SERVER – How to Change Database Compatibility Level?
After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
SQL SERVER – 5 Tips to Optimize SQL Server Application Performance
I recently talked with Mark Wright, CTO of Nitrosphere, a company that optimizes SQL Server application performance. Let us talk about it.
SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check
Today’s blog post created from a recent conversation with one of my customers. They asked me a very interesting question – “When should they hire me for my famous Comprehensive Database Performance Health Check?”. I send them following 10 questions and told them to take a quick quiz about their SQL Server Environment. They replied back to with YES to all the answers. If the answer to any of the following questions in YES, that means user can for sure improve your SQL Server’s Performance. After taking this quick test, my customer realized that they have amazing potential to improve the performance of their server.
SQL Server Performance Tuning Practical Workshop – Notes and Thoughts
In the month of January, I offered exclusive training to my newsletter subscribers. The training was extremely unique and was available for a limited time. Quite a lot of newsletter subscribers took advantage of this limited time offer of “SQL Server Performance Tuning Practical Workshop”.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
GroupBy Conference – 3 Common Mistakes to Kill SQL Server Performance
Earlier this year, I was fortunate to take part in the first edition of the Group By Conference organized by Brent Ozar. I was extremely fortunate that I was able to present an hour long presentation on the subject 3 Common Mistakes to Kill SQL Server Performance.