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?
PostgreSQL Learning Path at Pluralsight
Today I want to share PostgreSQL Learning Path at Pluralsight where you can learn this technology systematically. PostgreSQL is known as Postgres as well.
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.