SQL Server

Server Configuration

SQL Server Memory Settings
Recommended MSDTC settings for using Distributed Transactions in SQL Server


SQL Server Agent

Change the owner on all SQL Agent Jobs

Databases

Find all Primary Keys With Non-Clustered Indexes
How To Compress All Tables And Indexes In A Database
Howto Shrink All Logfiles On SQL Server

Random SQL Stuff

SQL Server 2008 R2 Evaluation Edition Expires


High Availability




Comments

Popular posts from this blog

Monitoring Raspberry Pi Performance Using Cacti

Using NAGIOS to Check the Physical Memory Available on a Windows Host

Error 2738 Occurs When Installing An MSI Package