A DMV version of sp_who2 returns the same session details from documented views and leaves out the system tasks. This post builds the query, shows why the old spid above 50 filter fails, and stores the result in a temporary table.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.
Unquoted Procedure Parameters: Are Single Quotes Optional?
Unquoted procedure parameters work in SQL Server when the value is one plain word. This post builds a small procedure and tests which values fail without single quotes. It also shows how NULL, DEFAULT and numbers change the value.
Change Database and Table Collation – SQL in Sixty Seconds #145
I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.
Top N Plus Others: Grouping the Rest Into One Row
Create top N plus others summaries with deterministic category ranking, one remainder total, stable labels, and explicit display ordering.
Infinite Loop – SQL in Sixty Seconds #144
Lots of people wrote feedback about it and wanted me to explain in this video so I have built this new Video where I discuss Infinite Loop.
SQL SERVER – Change Database and Table Collation
To Change Database collation, I separate its default from existing character-column settings. The customer moved from case-insensitive to case-sensitive behavior.