This episode of SQL in Sixty seconds is very special as it contains 9 SQL SERVER Performance Tuning Tips. The length of the video is also longer.
This video is hosted on SQLPASS youtube channel: Neutralize Troublesome SQL Server Indexes – Fun Stories & Demos. Let us watch it.
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.
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.
Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.