How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
Index Maintenance on Modern Storage
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.
SQL SERVER – MS TechNet : Storage Top 10 Best Practices
My pick of the Storage Top 10 Best Practices from MS TechNet: know your IO, keep designs simple, put logs on RAID 1+0, isolate logs from data and plan TEMPDB.
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.