Setting up Database Mail for alerts means creating an account and profile, testing delivery, linking Agent, and checking the queue when mail stops.
Comparing Server Settings Across Instances
Comparing server settings across SQL Server instances shows configured and live values, so you can judge which differences affect a workload.
Configuration Drift Between Servers
Find configuration drift between SQL Server instances, establish a baseline, and separate approved exceptions from settings that need repair.
Consolidating Small Instances Onto One Server
Consolidating small instances can reduce hardware sprawl when configuration conflicts, peak workloads, licensing, and migration order are checked.
SQL SERVER – Change Default Fill Factor For Index
The Default Fill Factor in SQL Server is 0. Change it with sp_configure to leave free space on index pages and reduce page splits. I like mine at 90.
Collecting Server Facts Into One Table Every Night
Collect Server Facts each night to track SQL Server versions, settings, databases, and file sizes in a practical history table.
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.