Soci (Soczó Zsolt) szakmai blogja


Új blog: Tips, Tricks, and Advice from the SQL Server Query Processing Team

Filed under: Adatbázisok,SQL Server 2005 — Soczó Zsolt @ 12:23 [RSS]

Eddig még csak néhány link van korábbi bejegyzésekre a témából. 

Tervek miről lesz szó:

  1. Memory management policies in QE and how to interpret memory-related issues based on system loads
  2. How to use information that can be collected from Showplan XML and Statistics Profile for execution analysis
  3. Efficient use of Distributed Queries
  4. Indexes and their role in Query Execution
  5. Data Manipulation Language (DML) including wide plans, narrow plans, etc.
  6. Parallel query execution – hints, tips, tricks, etc.
  7. Execution plan caching 

     – what is it and how does it help?

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress