REPLACE with COLLATE controls which substrings match. Preview case-dependent results before applying a text replacement policy.
SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
Why does SELECT * miss a new column? The adding column issue in view stays until you refresh it with sp_refreshview. Limitation of the view number 4.
SQL SERVER – What are Wait Types, Wait Stats and its Importance
What are wait types and wait stats, and why do they matter? A simple explanation of the three kinds of wait types, starting with resource waits.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.
Contained Database Users: Logins That Move With the Database
Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
An improved script to find row count in table for every table and spot the largest table in the database, now with the schema name, thanks to Ameena.
FOR JSON PATH: Choose Whether NULL Properties Appear
FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output example.