By Dusan Petkovic, 05/23/2006
Aggregate and rank window functions benefit BI projects.
By Christian Unterreitmeier, 11/20/2001
SQL Server's query optimizer effectively executes queries that access skewed data, but you can help improve the response time of such queries. Here's how.
By Christian Unterreitmeier, 04/20/2000
Defining the right indexes on sort columns can yield dramatic performance results for queries that need ordered data.
By Dusan Petkovic, 11/18/1999
It can be difficult to determine whether a table scan or an index will provide better query
performance. The answer depends in part, on the percentage of rows returned, but ...
By Christian Unterreitmeier, 07/01/1999
The query processor is one of the most important database system components that influence the management of large databases. SQL Server 7.0's focus is on new techniques for ...