Welcome to MSDN Blogs Sign in | Join | Help

April 2005 - Posts

Sunday, April 17, 2005 1:07 AM

SQL Server 2000 Sizing and Capacity Planning

Found two useful things on the internet today: Planning for Consolidation guide from microsoft: http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx A guideline from network appliance: http://www.netapp.com/tech_library/ftp/3363.pd
Posted by weix | 1 Comments
Sunday, April 17, 2005 12:43 AM

Beginner: Manage database file size

<Rewrote from my newgroup post> Case: 4GB database with two "big" tables: 1.5 million records, table with almost 1 million records, and each month, import about 300,000 records, also delete some old records. database goes up to 5 or 6 GB and the
Posted by weix | 1 Comments
Monday, April 04, 2005 2:21 AM

plan caching in sql 2005

I have not posted for almost 2 weeks. I have been very busy with Yukon work. Today this paper come to my attention, I think it is very useful for anyone who are interested in performance tuning in SQL 2005. http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.msp
Posted by weix | 0 Comments
 
Page view tracker