A composite index orders rows by its leading key before the next key. Compare a date-only filter, region restrictions and an isolated date-first index. Verify complete results, including new regions and NULL, before interpreting actual plans.
Error 4214: BACKUP LOG Needs a Full Backup First
Error 4214 stops a log backup because SQL Server has no full backup to build on. It shows up after a switch from Simple to Full recovery, or on a database that never had a full backup. Take one full backup, and the log backup works.
SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
SSMS 2008 has built-in activity and Performance Reports most people never open. Right click the server, go to Reports, Standard Reports, and pick one.
datetime: Read Its Fractional-Second Rounding
datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.
Reading a Network Trace of a SQL Server Connection
Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.
JSON_ARRAY: Choose Whether NULL Elements Are Included
JSON_ARRAY constructs typed array text. Choose whether missing inputs disappear or remain JSON null placeholders before relying on positions.
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.