Four bytes look like a bargain until a total comes out wrong. Watch real round, overflow and drift, then decide when decimal is the safer pick.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)
Msg 3201, cannot open backup device, operating system error 5 (Access is denied). The SQL Server service account needed permission on the disk.
Page Density: The Fragmentation Number That Actually Slows Scans
Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
Data, Log and tempdb File Placement: Checking Where Everything Lives
Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.
SQL SERVER – Computed Column – PERSISTED and Storage – Part 2
Part 2 of my look at the computed column and its effect on storage, with a list of the earlier articles in the series on PERSISTED storage and performance.
SQL SERVER – Computed Column – PERSISTED and Storage
How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.