Sign In
Engine Watch
database engine technology and SQL Server
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
No tags have been created or used yet.
Archive
Archives
March 2006
(1)
January 2006
(1)
November 2005
(2)
October 2005
(2)
September 2005
(5)
August 2005
(4)
July 2005
(3)
June 2005
(2)
May 2005
(3)
April 2005
(3)
March 2005
(6)
February 2005
(3)
January 2005
(2)
November 2004
(5)
October 2004
(4)
September, 2005
MSDN Blogs
>
Engine Watch
>
September, 2005
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Engine Watch
[SQL Server 2005] TEMPDB optimization
Posted
over 7 years ago
by
weix
3
Comments
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...
Engine Watch
[SQL 7.0] capacity planning tips
Posted
over 7 years ago
by
weix
0
Comments
This is really old, but some tips are still potentially useful: http://www.microsoft.com/technet/prodtechnol/sql/70/tips/storagen.mspx
Engine Watch
SQL 2000: stored proc recompile
Posted
over 7 years ago
by
weix
0
Comments
Old article but still very useful: http://support.microsoft.com/default.aspx?scid=kb;en-us;243586
Engine Watch
SQL 2000: what to do if tempdb grows to be very big
Posted
over 7 years ago
by
weix
1
Comments
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...
Engine Watch
SQL 2005: TSQL enhancements
Posted
over 7 years ago
by
weix
1
Comments
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
Page 1 of 1 (5 items)