SQL Server articles, tips and tricks

Home About me and Nucleus Partners Links Articles, tips etc. My blog Microsoft articles Newsgroups Course demo files Sync logins SMTP Alerter

Over the years, you run into frequently asked questions and issues that you find worthwhile looking a bit deeper into. Here, I have collected such elaborations, tips and tricks. Information, developer related Updated: The ultimate guide to the datetime datatypes Stored procedure recompiles and SET options Cross-reference between ANSI and SQL Server datatypes Cross-reference between ANSI and SQL Server functions Generate DDL scripts Information, administration related Why you want to be restrictive with shrink of database files Recommended actions for corrupt or suspect databases Minimizing data loss when accidents happens A MAPI free SQL Server world Changing the name of a SQL Server machine BACKUP using NO_TRUNCATE and RESTORE Utilities New: sp_indexinfo - enhanced index information procedure TSQL script to create backup file including database name, date and time Updated: Restore all databases from a number of backup files in a directory