Recently I was helping my client with a health check and we walked into a very interesting scenario. We had to change the database collation.
SQL SERVER – Writing Infinite Loop
We had to write a loop that runs continuously at every one second and captures the details. Let us learn how we can write an infinite loop.
SQL SERVER – Query Shortcuts
One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.
SQL SERVER – Network Port Used
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.