This video is hosted on SQLPASS youtube channel: Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos. Let us watch it.
MySQL MariaDB – Query Using Temp Table
SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
SQL SERVER – Representing sp_who2 with DMVs
A client wanted to capture sp_who2 details in a table. Here is how I represent sp_who2 with DMVs, so the data is easy to store and query.
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 – TOP and DISTINCT – Epic Confusion – SQL in Sixty Seconds #141
DBAs from the client’s organization ended up an argument about how T-SQL works. The discussion was about the epic confusion about TOP and DISTINCT.
How to Write Efficient Query? – Interview Question of the Week #300
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
SQL SERVER – Follow Up Question on Write Efficient Query
Earlier this week, I published a video Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140. The video got amazing feedback.