Nucleus Datakonsult SQL Server articles, tips and tricks

Home

About me and Nucleus
Partners

Articles, tips etc.
My blog
Links
Microsoft articles
Forums

Courses and training




Microsoft Most Valuable Professional


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

BACKUP using NO_TRUNCATE and RESTORE

Utilities
Rebuild all fragmented heaps on a SQL Server (new)
Pause random number of minutes or seconds
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
sp_tableinfo - list tables and space usage
sp_indexinfo - enhanced index information procedure (modified)
TSQL script to create backup file including database name, date and time
Restore all databases from a number of backup files in a directory