We had to write a loop that runs continuously at every one second and captures the details. Let us learn how we can write an infinite loop.
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
SQL SERVER – Query Shortcuts
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.
SQL SERVER – Network Port Used
During the recent Comprehensive Database Performance Health Check, I got a question from a client if there is an easy way to figure out the Network port.
SQL SERVER – Capturing INSERT Timestamp in Table
The other day while working on a topic of Comprehensive Database Performance Health Check recently asked if I know any trick for capturing insert timestamp.
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 – Logical Processing Order of the SELECT Statement
Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.
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?