Recently a client asked me during Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system.
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.
Yesterday’s blog was also a 5286 continuous blog (today’s blog is 5287th). I am truly honored that many are reading my blog after 14 years.
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.