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 – 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.Â
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.
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.
SQL SERVER – Identity and Constraint Confusion
What is going on with their server as I had no access to their data or schema. Let us learn about how identity and constraint confusion created problems.
SQL SERVER – Adding Values Containing NULLs
Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.