Navigation

Search

Site Content

Syndicate

Home | SQL Server 2005 DBA

Using a Numbers or Tally Table for Query Performance

Thu, 05/08/2008 - 22:38 |  sqlguychuck
Your rating: None Average: 4 (3 votes)

SQLServerCentral author Jeff Moden has a great introductory write up on the uses of Nums/Numbers/Tally tables for ultimate performance out of SQL queries. There are more uses than just replacing cursors and while loops, but his use of cross joins was new to me and very cool.

Share this  |  Login or register to post comments |  Tags: SQL 2005 Dev

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2010 SQLWebpedia. All Rights Reserved.

Creative Commons License
This work by Chuck Lathrope is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Disclaimer for all content: No warranty is expressed or implied by the authors' or owner's of this website or content linked externally. Use at your own risk.