SQL Server Hints and Tricks
Presented by Stephen G. Bergkamp at DSAFutures.com

This page contains tips and tricks I have learned through my daily use of SQL Server.  I am a DBA wth 15+ years of experience on SQL Server, Sybase, Oracle, Red Brick and some other RDBMS, (some I won't even claim).  You can see some of my experience on my resume page. If you have corrections or additions, please email me at:  steve.bergkamp@dsafutrues.com.

List of Tips:

Multi File, "Striped", backups.

backup database bnalogging to disk='\\bna-fs2\sqlbackups\bnasql1\bnalogging_033105_1.bak',
disk='\\bna-fs2\sqlbackups\bnasql1\bnalogging_033105_2.bak',
disk='\\bna-fs2\sqlbackups\bnasql1\bnalogging_033105_3.bak',
disk='\\bna-fs2\sqlbackups\bnasql1\bnalogging_033105_4.bak',
disk='\\bna-fs2\sqlbackups\bnasql1\bnalogging_033105_5.bak'
with stats=1

The Last Hint