Welcome to MSDN Blogs Sign in | Join | Help

June 2005 - Posts

Microsoft SQL Server 2000 Index Defragmentation Best Practices

This is a very good white paper on this important topic http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
Posted by weix | 2 Comments

temp table allocation in SQL 2005

Temp table is no different from regular tables. We may choose either page or extent allocation to optimize performance and space utilization. The kinds of operation affect how we choose: select into bulk insert create index insert How full the tables
Posted by weix | 1 Comments
 
Page view tracker