Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.
Data Types That Waste Space
Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
At MIS2007 we had a database RAID discussion: RAID 5 or RAID 10 for databases from 5 GB to 5 TB. Almost everyone picked RAID 10, even though it costs more.
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
Error 1101, could not allocate a new page because of insufficient disk space in filegroup. Free up hard disk space and turn on AUTOGROW for the filegroups.
SQL SERVER – Raid Configuration – RAID 10
Which RAID do I use for my SQL Servers? RAID 10. It gives great read and write performance, while RAID 5 pays a write penalty for parity.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
When TempDB is Full, I investigate capacity and usage before moving its files. A move requires a planned restart.