During the recent Comprehensive Database Performance Health Check, I got a question from a client if there is an easy way to figure out the Network port.
SQL SERVER – Capturing INSERT Timestamp in Table
The other day while working on a topic of  Comprehensive Database Performance Health Check recently asked if I know any trick for capturing insert timestamp.
SQL SERVER Management Studio – Word Wrap
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.