|
|
|
Date Submitted:
08/04/05
Hits: 71 Rating:  based on 0 votes
Save Space To Boost SQL Server PerformanceAdded by Papergrl
Description:
If you have ever looked at an Execution Plan for a SQL Server query (and if you haven't, you should!) you will see that SQL Server produces an estimated "cost" for executing queries. This cost is not in money terms, obviously, but in terms of computer resources required to run the query. The primary component of this costing is disk I/O, so it stands to reason that if we can reduce disk I/O, then we reduce the cost of executing a query, and therefore increase performance. In this article we will look at a few ways of doing this.
Read the Complete Paper You don't have permission to post replies. Please login or register. |