Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
Development
,
SQL Server 2005
Items 1 to 20 of 77
Older >>
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,263 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,175 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,138 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,633 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,023 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,375 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
|
894 reads
usp_dependencytree
displays a graphical tree of dependencies of an object
Read more...
By
Wilfred van Dijk
2008/06/25
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
283 reads
Recursive Queries in SQL Server 2005
Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
Read more...
By
Srinivas Sampath
2008/04/18 (first published: 2005/03/03)
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
92,490 reads
Reporting Services Makes Server Support Easier
Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers
Read more...
By
Carolyn Richardson
2007/03/12
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
8,771 reads
Maximum Row Size in SQL Server 2005
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
Read more...
By
Andy Warren
2007/02/27
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
24,974 reads
An Introduction to the Service Broker
One of the more interesting new features in SQL Server 2005 is the Service Broker. It's not something to help you manage your financial future, nor is it some new program that handles all the instances and their accounts. It's a message queue and SQL Server MVP Srinivas Sampath brings us a look at this new feature with some code to get you going.
Read more...
By
Srinivas Sampath
2007/12/14 (first published: 2005/06/30)
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
31,306 reads
Source Control in SQL Server
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
Read more...
By
Vasant Raj
2006/12/04
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
13,806 reads
New T-SQL Features in SQL Server 2005 Part 2
SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the second part in a series looking at what these changes do and how to use them.
Read more...
By
Sureshkumar Ramakrishnan
2006/12/06
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
20,059 reads
New T-SQL Features in SQL Server 2005 Part 1
SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the first part in a series looking at what these changes do and how to use them.
Read more...
By
Sureshkumar Ramakrishnan
2006/11/29
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
27,451 reads
Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.
Read more...
By
Additional Articles
2007/09/28
|
Source:
SQL Server Performance
|
Category:
development
Rating:
Rate this
|
Briefcase
|
4,338 reads
An Auditing Solution with XML And XSL
Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.
Read more...
By
David McKinney
2007/08/20
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
5,055 reads
Building a Partitioned Table
One of the nice new features in SQL Server 2005 is the ability to partition a table based on some sort of range in the data. New author Irfan Baig brings us a short article that explains exactly how you can get started using this new feature.
Read more...
By
Irfan Baig
2007/08/14
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
8,174 reads
Table Partitioning
One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.
Read more...
By
Andy Warren
2007/08/09
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
19,906 reads
Transaction Isolation and the New Snapshot Isolation Level
Concurrency and transaction isolation are a prickly subject, difficult to explain with any kind of clarity without boring the reader and leaving their poor brain in a complete muddle. Therefore, it is often ignored in the vain hope it won't affect us and we can forget all about it. Well you can't ignore it any more and with SQL Server 2005 there's a whole new isolation level added to the four that already exist.
Read more...
By
Additional Articles
2007/07/19
|
Source:
SQLTeam.com
|
Category:
development
Rating:
Rate this
|
Briefcase
|
2,256 reads
Items 1 to 20 of 77
Older >>
Tags
t-sql
(9)
advanced querying
(7)
nums
(7)
sqlinsider scripts
(7)
table of numbers
(7)
tally
(7)
administration
(6)
counter
(6)
arrays
(5)
delimited strings
(5)
parse
(5)
string manipulation
(5)
miscellaneous
(4)
sql server 7
(3)
.net
(2)
2-dimensional arrays
(2)
programming
(2)
security
(2)
strategies
(2)
dependencies
(1)
integration services (ssis)
(1)
prime
(1)
prime number
(1)
reporting services (ssrs)
(1)
sieve
(1)
stored procedures
(1)
table
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.