http://www.sqlmag.com/authors/author/author/5196519/rss/5196519en-USFri, 25 May 2012 10:52:29 GMTFri, 25 May 2012 10:52:29 GMThttp://www.sqlmag.com/article/tsql3/open-windows-of-opportunityAggregate and rank window functions benefit BI projects.]]>Dusan PetkovicTue, 23 May 2006 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/open-windows-of-opportunityhttp://www.sqlmag.com/article/quering/taming-the-skewSQL 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.]]>Christian UnterreitmeierTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/quering/taming-the-skewhttp://www.sqlmag.com/article/data-access/indexing-for-sort-performanceDefining the right indexes on sort columns can yield dramatic performance results for queries that need ordered data.]]>Christian UnterreitmeierThu, 20 Apr 2000 15:45:31 GMThttp://www.sqlmag.com/article/data-access/indexing-for-sort-performancehttp://www.sqlmag.com/article/performance/which-is-faster-index-access-or-table-scan-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 another important factor is whether you use a clustered or nonclustered index. ]]>Dusan PetkovicThu, 18 Nov 1999 14:39:02 GMThttp://www.sqlmag.com/article/performance/which-is-faster-index-access-or-table-scan-http://www.sqlmag.com/article/performance/new-features-for-query-processingThe 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 maximizing your query performance.]]>Christian UnterreitmeierThu, 01 Jul 1999 00:00:00 GMThttp://www.sqlmag.com/article/performance/new-features-for-query-processing