<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 tag
T-SQL Aids
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(385)
Index Management
(24)
SQL Server 2000
(3)
Backup
(1)
Maintenance and Management
(212)
Lock and Connection Management
(15)
SQL Server 2005
(2)
Restore
(1)
SQLInsider Scripts
(116)
Replication
(9)
T-SQL
(2)
Scripts
(1)
Backup / Restore
(37)
Mail
(8)
Advanced Querying
(1)
String Manipulation
(1)
Data Warehouse
(27)
Full-Text Search (2005)
(3)
Items 1 to 20 of 625
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 all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,195 reads
create log tables and trigger modyfied
Read more...
By
mobasha B
2007/11/14
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
366 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
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,456 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,456 reads
Create Log tables and Triggers
Read more...
By
Srinivasulu Nasam
2007/10/26
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,520 reads
Find Table Usage
Read more...
By
kgayda
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,021 reads
Find Column Name Usage
Read more...
By
kgayda
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,933 reads
Function to Split Multivalued Parameter
Read more...
By
~~Hari.Bagra
2007/10/11
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
907 reads
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,281 reads
Find Table Usage
Read more...
By
kgayda
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,021 reads
Find Column Name Usage
Read more...
By
kgayda
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,933 reads
create an insert statement
Read more...
By
Jerrin
2007/10/01
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
1,338 reads
Extracting words with removal of punctuations
Read more...
By
Yousef Ekhtiari
2007/09/26
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
907 reads
Items 1 to 20 of 625
Next 20 >>
Most popular
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,281 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,223 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,195 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
