Unreported SQL Server Agent Job Failures
SQL Server Agent provides an easy-to-configure framework for notifying DBAs when jobs fail to run for any reason. Unfortunately, there are circumstances where job failures may not result in SQL Server sending a notification. For…
Language used by the SQL Server binaries
SQL Server binaries come in various languages, such as 日本語 (Japanese), French, and English. It’s pretty easy to determine the language once SQL Server is *running*. A simple query does the trick:
|
1 2 3 4 |
SELECT sl.name , sl.alias FROM sys.syslanguages sl WHERE sl.lcid = SERVERPROPERTY('lcid'); |
However, if…
How long since you ran DBCC CHECKDB?
If you’re not regularly looking for corrupt databases with DBCC CHECKDB, you’re putting your organization’s data at risk. I run DBCC CHECKDB once per day, or as is reasonably possible. Typically, DBCC CHECKDB is setup…
Index reorg/rebuild script
Index fragmentation may be causing more I/O than necessary for efficient query processing. Fragmentation occurs as a result of inserting items into the middle of the index instead of appending them to the end. Inserting…
Modify device path for multiple Backup Devices
Backup Devices provide a nice way to permanently configure the backup location, enabling BACKUP DATABASE to look like:
|
1 |
BACKUP DATABASE [xyz] TO [backup-device-name]; |
When you create a Backup Device, you specify the physical location where backups will actually be…
Statistics update job
SQL Server statistics are extremely important for good query performance since they provide invaluable guidelines that allow the query optimizer to pick an optimal plan. Out-of-date or non-existent statistics objects can cause excessive I/O, poor…