Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Advanced Querying, SQL Server 2005 Rss

   Items 1 to 13 of 13   
 

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,485 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.  Read more...
By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 1,208 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,134 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,075 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,589 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,003 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,272 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 878 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,485 reads

Introduction to Parameterization in SQL Server

In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL   Read more...
By Additional Articles 2007/08/14 | Source: SQLTeam.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,046 reads

Write PIVOT queries in SQL Server 2005

New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.  Read more...
By Additional Articles 2007/01/11 | Source: Builder.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 5,354 reads

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.  Read more...
By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 3,918 reads

Fast Text Processing in SQL Server

Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.   Read more...
By Additional Articles 2006/05/10 | Source: DevX | Category: advanced querying
Rating:  Rate this |   Briefcase | 4,505 reads
   Items 1 to 13 of 13   
 
Tags
t-sql (12)    
development (7)    
nums (7)    
sqlinsider scripts (7)    
table of numbers (7)    
tally (7)    
counter (6)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
miscellaneous (3)    
sql server 7 (3)    
2-dimensional arrays (2)    
administration (1)    
games (1)    
performance tuning (1)    
prime (1)    
prime number (1)    
puzzle (1)    
sieve (1)    
table (1)