Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.
In today’s blog post we are going to watch a free video about how you can easily spot poor SQL Server performance in your system.
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete and meaningful to you.
This is a buy one get one to my recorded class SQL Server Performance Tuning Practical Workshop for EVERYONE. Very unique offer for everyone!
Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.