Welcome to MSDN Blogs Sign in | Join | Help

September 2005 - Posts

Tuesday, September 13, 2005 11:12 AM

[SQL Server 2005] TEMPDB optimization

In SQL 2005 we have done quite a bit of internal improvements in tempdb scalability. These include: Caching of IAM and first data page for temp table and table variables. Improved allocation page latching protocol so that we use UP latch less frequently.
Posted by weix | 3 Comments
Friday, September 09, 2005 1:05 AM

[SQL 7.0] capacity planning tips

This is really old, but some tips are still potentially useful: http://www.microsoft.com/technet/prodtechnol/sql/70/tips/storagen.mspx
Posted by weix | 0 Comments
Thursday, September 08, 2005 9:28 PM

SQL 2000: stored proc recompile

Old article but still very useful: http://support.microsoft.com/default.aspx?scid=kb;en-us;243586
Posted by weix | 0 Comments
Thursday, September 08, 2005 8:59 PM

SQL 2000: what to do if tempdb grows to be very big

Unless your workload changed significantly, shrink file is not going to help you because tempdb will just grow back if a query needs that amount of free space. So a better way is to identify the query and try to optimize that, maybe by adding an index.
Posted by weix | 1 Comments
Friday, September 02, 2005 9:58 PM

SQL 2005: TSQL enhancements

Click the following link to learn things like: TOP, RANK, ROW_NUMBER, PIVOT, Recursion... http://www.awprofessional.com/articles/article.asp?p=327394&seqNum=7&rl=1
Posted by weix | 1 Comments
 
Page view tracker