<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><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
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Development
,
T-SQL
Items 1 to 16 of 16
Column Size Checker
A T-SQL script that reveals how appropriate your choice of column sizes is.
Read more...
By
Richard Doering
2010/12/30
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,201 reads
Column Size Checker
A T-SQL script that reveals how appropriate your choice of column sizes is.
Read more...
By
Richard Doering
2010/12/30
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,201 reads
Execute SQL Scripts in paralel for real performance tests
Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.
Read more...
By
Gustavo Maia
2009/09/30
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
1,754 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,177 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,088 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,018 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,540 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
|
979 reads
Introduction to DML Triggers
This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.
Read more...
By
Jack Corbett
2008/10/14
|
Source:
SQLServerCentral.com
|
Category:
triggers
Rating:
|
Discuss
|
Briefcase
|
12,427 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
2013/05/25
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,160 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
2013/05/25
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
864 reads
Counter Table (table of numbers) Setter-Upper for SQL Server 2000
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
Read more...
By
Jesse Roberge
2013/05/25
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
442 reads
usp_addcolumns
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
Read more...
By
Wilfred van Dijk
2008/07/01
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
583 reads
Automatically generate SUID procs for any table
This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.
Read more...
By
Cade Bryant
2008/01/02
|
Source:
SQLServerCentral.com
|
Category:
automation
Rating:
|
Discuss
|
Briefcase
|
1,191 reads
SQL Server Error Handling Workbench
Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.
Read more...
By
Additional Articles
2007/03/06
|
Source:
SimpleTalk
|
Category:
stored procedures
Rating:
Rate this
|
Briefcase
|
3,016 reads
Fixing SysDepends
Have you been burned by sysdepends at some point in your SQL Server DBA career? Steve Jones has many times, but a FREE new utility ends all that.
Read more...
By
Steve Jones
2005/09/22
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
9,636 reads
Items 1 to 16 of 16
Tags
sql server 2005
(9)
advanced querying
(8)
nums
(8)
sqlinsider scripts
(8)
table of numbers
(8)
tally
(8)
counter
(7)
arrays
(5)
delimited strings
(5)
parse
(5)
string manipulation
(5)
miscellaneous
(4)
sql server 7
(4)
2-dimensional arrays
(2)
stored procedures
(2)
table
(2)
administration
(1)
automation
(1)
palalelism
(1)
prime
(1)
prime number
(1)
sieve
(1)
stress test
(1)
triggers
(1)
utility
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
