Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.

September 26, 2006 / by Zsolt Soczó

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

http://blogs.msdn.com/sqlqueryprocessing/default.aspx [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?

Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.