Recently a client asked me during Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system.
SQL SERVER – Multiple Optimize Hint for a Query
An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.
SQL SERVER – Distinct and ORDER BY
I have made note that ORDER BY is not required when DISTINCT is used. Let us understand the same subject in detail. Let us learn today.
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.
SQL SERVER – CREATE Statement in TRANSACTION
Recently my client of Comprehensive Database Performance Health Check asked me if we can use the CREATE statement in the TRANSACTION or not.
SQL Authority 14 Years of Daily Blogging and Upcoming Changes
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.
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.
Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140
Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.
SQL SERVER – Fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached
When we tried to run a few of their stored procedure. How we can fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached.