I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
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.