One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.
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.
5 SQL in Sixty Seconds Video on SSMS Efficiency
I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency.
SQL SERVER – Configurable KeyBoard Query Shortcuts for SSMS
Today we will learn something very simple but fun stuff for SQL Server Management Studio (SSMS) which is about Configurable KeyBoard Query Shortcuts.
SQL SERVER Management Studio – Word Wrap
One of the requests I usually do to my client when they are using SQL Server Management Studio is around Word Wrap. Let us learn about it today.
SQL SERVER – What is Logical Read?
Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.
Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140
Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.