1st-SQL Server Query Optimization!

This topic is SQL Server query optimization.
Query optimization is a common topic,
In actual production applications, queries with large data volumes consume a large amount of resources on the server,
How to optimize queries reasonably to improve system performance,
It is a topic of common concern among system architects, system development heat sources, system maintenance personnel, and database management personnel.
This topic will be discussed here.
Welcome to participate actively .:)
Post a few articles as a reference.
How to optimize the query.
Http://topic.csdn.net/u/20080416/08/24b62a73-ab5a-4927-97af-81e7e790445d.html
Basic Principles of indexing and how data is accessed
Http://topic.csdn.net/u/20080521/15/c5ee330e-596d-4957-8032-5bb9a80a9218.html
100: How to Improve the query performance in sqlserver! The more comprehensive the better!
Http://topic.csdn.net/u/20080624/10/0ac05d43-b285-49f0-85b2-73e0d989d2ae.html
In-depth exploration: clustered index scan vs table Scan
Http://topic.csdn.net/u/20080707/09/3c64cc80-5f7a-4116-8942-81c6deae9c07.html
Five Ways to Improve SQL Performance
Http://dev.csdn.net/author/griefforyou/082b9b29299e4584b78bf6f7ccb57c0b.html
Database Query Optimization Technology
Http://bbs.chinaunix.net/viewthread.php? Tid = 83481

Query Optimization
Http://msdn.microsoft.com/zh-cn/library/ms176005.aspx

Analysis Query
Http://msdn.microsoft.com/zh-cn/library/ms191227.aspx

Search for Missing Indexes
Http://msdn.microsoft.com/zh-cn/library/ms345417.aspx

Query Optimization suggestions
Http://msdn.microsoft.com/zh-cn/library/ms188722.aspx

Advanced query optimization concepts
Http://msdn.microsoft.com/zh-cn/library/ms191426.aspx


Some blogs and English documents.
--------------------------------------
Tips, tricks, and advice from the SQL Server Query Optimization Team
Http://blogs.msdn.com/QueryOptTeam/
Http://blogs.msdn.com/sqlqueryprocessing/default.aspx

SQL Server 2000 query Tuning
Http://msdn.microsoft.com/en-us/library/aa178417 (SQL .80). aspx
Analyzing A Query
Http://msdn.microsoft.com/en-us/library/aa178303 (SQL .80). aspx
Query tuning recommendations
Http://msdn.microsoft.com/en-us/library/aa178391 (SQL .80). aspx
Advanced query tuning concepts
Http://msdn.microsoft.com/en-us/library/aa178578 (SQL .80). aspx

Some "hints" for mastering SQL Tuning
Http://www.devx.com/dbzone/Article/26995

Transact-SQL query performance tuning tips
Http://www.dotnetheaven.com/UploadFile/skrishnasamy/SQLPerformanceTunning03112005044423AM/SQLPerformanceTunning.aspx

SQL Server 2005 query Tuning
Http://msdn.microsoft.com/en-us/library/ms176005.aspx

Analyzing A Query
Http://msdn.microsoft.com/en-us/library/ms191227.aspx

Finding Missing Indexes
Http://msdn.microsoft.com/en-us/library/ms345417.aspx

Query tuning recommendations
Http://msdn.microsoft.com/en-us/library/ms188722.aspx

Advanced query tuning concepts
Http://msdn.microsoft.com/en-us/library/ms191426.aspx

Deeper insight into unused indexes for SQL Server 2005
Http://www.mssqltips.com/tip.asp? Tip = 1545

Use missing-index groups for query Tuning
Http://www.sqlmag.com/Article/ArticleID/95220/ SQL _server_95220.html

2 stored procedures to tune your Indexes
Http://www.sqlmag.com/Article/ArticleID/98019/98019.html? Feed = articlelink

What I wish developers knew about SQL Server (presentation)
Http://www.sqlteam.com/article/what-i-wish-developers-knew-about-sql-server-presentation.
This is the latest version of this presentation including all demonstration scripts. the presentation has been converted to a PDF to make viewing easier. the presentation provides an overview of query plans, query tuning tips, Nulls, error handling and transactions.
The presentation and demo scripts.
Http://www.sqlteam.com/downloads/WhatIWishPresentation.zip

Avoid enclosing indexed columns in a function in the WHERE clause
Http://www.sqlteam.com/article/avoid-enclosing-indexed-columns-in-a-function-in-the-where-clause

Introduction to parameterization in SQL Server
Http://www.sqlteam.com/article/introduction-to-parameterization-in-sql-server

Best practices for query parameterization
Http://www.sqlteam.com/article/best-practices-for-query-parameterization

Query parameterization and plan Cache
Http://blogs.msdn.com/sqlprogrammability/archive/2007/01/11/4-0-query-parameterization.aspx
This comes to us from the SQL Server programmability and API team blog. they write "using parameters or parameter markers in queries increases the ability of SQL Server to reuse compiled plans. there are two places where parameterization of queries can be done: on the client side application (or mid tier) or on the server side."

Analyzing and optimizing T-SQL query performance on Microsoft SQL Server using set and DBCC (PDF)
Http://www.sqlteam.com/article/analyzing-and-optimizing-t-sql-query-performance-on-microsoft-sql-server-using-set-and-dbcc-pdf

Five Ways to rev up your SQL Performance
Http://msdn.microsoft.com/en-us/magazine/cc301622.aspx
This article already contains Chinese translations (five ways to improve SQL Performance)

Finally, we recommend a tuning book.
Inside SQL Server 2005: Query tuning and Optimization
Http://download.csdn.net/source/421022



[Share] database optimization policies
Http://topic.csdn.net/u/20081007/22/71c40590-3bac-4848-b82a-416692b8b8c6.html