## Content with tags T-SQL, Tally Table

Items 1 to 20 of 22    Older >>

### Nasty Fast N-Grams (Part 1): Character-Level Unigrams

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.  Read more...
By Alan Burstein 2016/06/23 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 1,959 reads

### PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,931 reads

### PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,931 reads

### A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2015/10/23 (first published: 2013/04/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,541 reads

### Counting the Tally Table

By Steve Jones 2015/10/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,518 reads

### PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,931 reads

### PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,931 reads

### PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,931 reads

### Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2014/09/19 (first published: 2012/11/13) | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 17,713 reads

### Divide and Conquer - Performance Tuning

Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance  Read more...
By Claire Mora 2014/04/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,839 reads

### A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2015/10/23 (first published: 2013/04/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,541 reads

### Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 62,977 reads

### Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?  Read more...
By Jeff Moden 2012/11/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,978 reads

### Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2014/09/19 (first published: 2012/11/13) | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 17,713 reads

### Hidden RBAR: Counting with Recursive CTE's

"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.  Read more...
By Jeff Moden 2011/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,231 reads

### Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 62,977 reads

### Tally Table Uses - Part II

In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.  Read more...
By Sioban Krzywicki 2010/08/03 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 8,926 reads

### Tally Table Uses - Part I

In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.  Read more...
By Sioban Krzywicki 2010/08/02 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 15,131 reads

### Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 42,558 reads

### Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...
By Seth Phelabaum 2009/12/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,637 reads
Items 1 to 20 of 22    Older >>

Tags
 adjacency list (2) cte (2) date manipulation (2) hierarchy (2) nested sets (2) set-based (2) string function (2) string manipulation (2) actual execution plan (1) binary flags (1) bit operations (1) blogs (1) crosstab (1) csv (1) data generation (1) date calculations (1) exclude pattern (1) iso (1) iso week (1) lookup table (1) n-grams (1) numbers table (1) patindex (1) pattern exclude (1) performance (1) pivot (1) recursion (1) scripts (1) sql performance (1) sqlprep (1) strings (1) text manipulation (1) text mining (1)