Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.
Grid vs Text Output in SSMS: Why Line Breaks Disappear
Grid vs text output is a Management Studio setting that decides whether the line breaks in your data stay visible. This post builds a value with a line break, proves with T-SQL that the data holds it, and shows how to keep the break in each mode.
SQL SERVER – Move a Table From One Schema to Another Schema
ALTER SCHEMA can Move a Table between schemas within one database. A customer had imported under the wrong schema.
Generate a Date Range: List All Dates Between Two Dates
To generate a date range in SQL Server, number the days between a start date and an end date and add each number to the start. This post shows a recursive CTE, its limit of 100 recursions, GENERATE_SERIES, a version for older servers, and how to handle times and missing days.
SQL SERVER – MARK_IN_USE_FOR_REMOVAL Cache Scope and Costs
To Remove Unused cache entries, I first inspect cache and workload evidence. My original intervention followed other customer tuning work.
SQL SERVER – Diagnosing SINGLE_USER Errors Without a Universal EMERGENCY Workaround
Giving Error during a SINGLE_USER change requires the exact error and database state. My original case lacked enough diagnostic detail.
Check Trace Flag Status With DBCC TRACESTATUS
DBCC TRACESTATUS checks trace flag status. Run it with -1 to list every flag that is on, or with flag numbers to test them one by one. This post turns on a harmless session flag, reads its scope, finds startup flags, and stores the result in a table.