Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
REGEXP_LIKE in SQL Server 2025: Validating Codes, Emails and Phone Numbers
Validate codes, email shapes and phone numbers with REGEXP_LIKE in SQL Server 2025, using clear patterns and CHECK constraints.
ASIN: A Sine Ratio Does Not Recover Every Original Angle
ASIN returns an angle from a sine ratio. Preserve the original branch, use explicit units and keep invalid or missing ratios visible.
What Is a Heap in SQL Server?
A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.
SQL SERVER – What DBCC Memory Cache Commands Actually Clear
SQL Server retains memory caches to support later work. I investigate memory pressure before trying to release them.
SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
ALTER LOGIN can enable, disable or rename a SQL Server login. I verify another administrative access path before changing sa.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.