<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
Advanced Querying
,
SQL Server 2005
Refine your search with one of the following additional tags (with number of items):
T-SQL
(11)
tally
(6)
String Manipulation
(5)
Administration
(1)
counter
(6)
T-SQL Aids
(6)
SQL Server 2000
(3)
games
(1)
Development
(6)
Arrays
(5)
2-Dimensional Arrays
(2)
Performance Tuning
(1)
nums
(6)
Delimited Strings
(5)
Miscellaneous
(2)
Puzzle
(1)
SQLInsider Scripts
(6)
Parsing
(5)
SQL Server 2005 - TSQL
(2)
Table
(1)
Table of Numbers
(6)
Items 1 to 11 of 11
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/10/23
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
56 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 Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
12 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 Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
34 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 Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
7 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
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
26 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
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
26 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
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,146 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
|
2,851 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
|
4,350 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,075 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
|
3,823 reads
Items 1 to 11 of 11
Most popular
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
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,146 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
|
2,851 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
|
4,350 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
