Sign in
Tips, Tricks, and Advice from the SQL Server Query Processing Team
The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Tags
Compilation time
data warehousing
Distinct aggregation
Estimate Rows
ETW
Hash Join
Indexing
Memory Management
OLAP
OLTP
optimizer
Query cost
query memory
query optimization
Query plan
Showplan
Showplan_XML
SQL Profiler
SQL Server 2005
SQL Trace
Star Join
Statistics Profile
Statistics XML
Tracing
Browse by Tags
MSDN Blogs
>
Tips, Tricks, and Advice from the SQL Server Query Processing Team
>
All Tags
>
oltp
Tagged Content List
Blog Post:
Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005
SQL Server Query Processor Team
I've helped a lot of people upgrade their SQL 2000 applications to SQL 2005. While many of these upgrades go well, occasionally some applications have issues and the overall workload may perform more poorly after the upgrade. One area where I've seen issues is with ad-hoc on-line transaction processing...
on
27 Sep 2006
Page 1 of 1 (1 items)