<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
Scripts with tag
T-SQL Aids
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(385)
Data Warehouse
(27)
Mail
(8)
Backup
(1)
Maintenance and Management
(212)
Index Management
(24)
Full-Text Search (2005)
(3)
Restore
(1)
SQLInsider Scripts
(116)
Lock and Connection Management
(15)
SQL Server 2000
(3)
String Manipulation
(1)
Backup / Restore
(37)
Replication
(9)
SQL Server 2005
(2)
T-SQL
(1)
Search for
any
content tagged
T-SQL Aids
Add a script
Items 1 to 20 of 624
Next 20 >>
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
Read more...
By
Simon Facer
2008/06/17
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
Read more...
By
Howard P. Lovecraft
2008/03/25
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
610 reads
Trim Trailing Blanks in SQL Queries
Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.
Read more...
By
Jesse McLain
2008/03/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
1,104 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
Read more...
By
Josep
2008/02/12
|
Source:
SQLServerCentral.com
|
Category:
Restore
Rating:
|
Discuss
|
Briefcase
|
879 reads
Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
Read more...
By
John Liu
2008/01/10
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
830 reads
Check Instance Info
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
Read more...
By
Pedro Lopes
2007/12/19
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2000
Rating:
|
Discuss
|
Briefcase
|
914 reads
Get Splitted Value From the String Format Specifie
Read more...
By
BeoWulf .
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
52 reads
Combine multiple rows into single output
Read more...
By
Mohit Nayyar
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
908 reads
Restore 2000 DB to 2005
Read more...
By
David A. Long
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
1,165 reads
LSTR() and RSTR(): Enhanced LEFT() and RIGHT()
Read more...
By
R. van Laake
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
145 reads
This SP will be create C# classes using all table
Read more...
By
Satya B
2007/11/13
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,447 reads
create log tables and trigger modyfied
Read more...
By
mobasha B
2007/11/14
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
366 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,197 reads
Display disk space stats for each table
Read more...
By
Andrew Greenall
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
274 reads
Get Record Count for each table in a database.
Read more...
By
~~Hari.Bagra
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
131 reads
Table row count using 3 different ways
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,046 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,457 reads
SSRS Multi-Select
Read more...
By
lane sandness
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
37 reads
Create Log tables and Triggers
Read more...
By
Srinivasulu Nasam
2007/10/26
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,520 reads
Function to Split Multivalued Parameter
Read more...
By
~~Hari.Bagra
2007/10/11
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
907 reads
Items 1 to 20 of 624
Next 20 >>
Most popular
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,282 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,226 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,197 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
