SQL Server articles, tips and tricks

Home About me and Nucleus Partners Articles, tips etc. My blog Links Microsoft articles Forums Courses and training

Here you find articles, tips and utilities I have written. Unlike blog posts, I do modify these from time to time. I try to have some update history in each srticle and for the more recently updated and new articles I also have some visual indication on this page. Information The ultimate guide to the datetime datatypes Moving a database between two SQL Server instances Large transaction log lile Why you want to be restrictive with shrink of database files Recommended actions for corrupt or suspect databases Minimizing data loss when accidents happens Changing the name of a SQL Server machine BACKUP using NO_TRUNCATE and RESTORE Utilities Analyze SQL Server and Agent errorlogs MailAfterJob - send email after Agent job, with status in mail subject and output files attached Agent Alerts Management Pack sp_dbinfo - database space usage information (updated) sp_tableinfo - list tables and space usage sp_indexinfo - enhanced index information procedure TSQL script to create backup file including database name, date and time Restore all databases from a number of backup files in a directory