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