DBA Recommended Reading
Deep Dive on Initialize from Backup for Transactional Replication
In my organization, I happened to set up a transactional replication for the whole database (240 gb) on which I ran the snapshot and ended up time out multiple times and gave up that initializing a full database transactional replication is not going to work out for large databases.
Later I came across the following link to setup transactional replication and initializing with backup option.
http://blogs.msdn.com/b/repltalk/archive/2010/03/16/deep-dive-on-initial...
This worked for me :-)
Thanks,
Ganesh
Top 10 Storage Tips for SQL 2005
The SQLCAT team has some great guidance on storage configuration for SQL server: http://sqlcat.com/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx
Summary
Top 10 OLTP Performance Issues SQL 2005
The SQLCAT team has a top ten list of OLTP performance issues: http://sqlcat.com/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx
Summary
Top 10 Hidden Gems in SQL 2005
The SQLCAT team has posted some good information about seldom used tools that should be of interest to many us: http://sqlcat.com/top10lists/archive/2007/11/21/top-10-hidden-gems-in-sql-server-2005.aspx
Summary
