<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>
Scripts with tag
Development
Search for
any
content tagged
development
Add a script
Items 1 to 17 of 17
iSpy (on your development)
Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases
Read more...
By
Rob Lobbe
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
schemas
Rating:
|
Discuss
|
Briefcase
|
496 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,205 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,765 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,090 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 - 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
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/06/20
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,161 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,544 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/06/20
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
865 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/06/20
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
442 reads
usp_dependencytree
displays a graphical tree of dependencies of an object
Read more...
By
Wilfred van Dijk
2013/06/20
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
236 reads
Find Mismatched Views and Stored Procs
Find missing and mismatched views and stored procs between 2 Databases
Read more...
By
Pratap Prabhu
2012/09/03
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
1,478 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
Truncate All Tables
Script to Truncate all tables part1
Read more...
By
Jorge Novo-@ETLDEVDBA
2011/06/02
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
7,354 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
Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
Read more...
By
Cade Bryant
2012/09/06
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
8,028 reads
Items 1 to 17 of 17
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
