One of the requests I usually do to my client when they are using SQL Server Management Studio is around Word Wrap. Let us learn about it today.
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 – 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 – 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.