<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
(384)
Data Warehouse
(27)
Mail
(8)
Restore
(1)
Maintenance and Management
(212)
Index Management
(24)
Full-Text Search (2005)
(3)
SQL Server 2005
(1)
SQLInsider Scripts
(116)
Lock and Connection Management
(15)
SQL Server 2000
(2)
String Manipulation
(1)
Backup / Restore
(37)
Replication
(9)
Backup
(1)
Search for
any
content tagged
T-SQL Aids
Add a script
Items 1 to 20 of 623
Next 20 >>
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
|
604 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,101 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
|
857 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
|
819 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
|
886 reads
Get Splitted Value From the String Format Specifie
Read more...
By
BeoWulf .
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
48 reads
Combine multiple rows into single output
Read more...
By
Mohit Nayyar
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
887 reads
Restore 2000 DB to 2005
Read more...
By
David A. Long
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
1,138 reads
LSTR() and RSTR(): Enhanced LEFT() and RIGHT()
Read more...
By
R. van Laake
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
140 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,440 reads
create log tables and trigger modyfied
Read more...
By
mobasha B
2007/11/14
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
364 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,108 reads
Display disk space stats for each table
Read more...
By
Andrew Greenall
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
266 reads
Get Record Count for each table in a database.
Read more...
By
~~Hari.Bagra
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
128 reads
Table row count using 3 different ways
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,030 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,448 reads
SSRS Multi-Select
Read more...
By
lane sandness
|
Category:
T-SQL Aids
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
36 reads
Create Log tables and Triggers
Read more...
By
Srinivasulu Nasam
2007/10/26
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,494 reads
Function to Split Multivalued Parameter
Read more...
By
~~Hari.Bagra
2007/10/11
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
898 reads
Row count of all tables
Read more...
By
Girish Patil
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
355 reads
Items 1 to 20 of 623
Next 20 >>
Most popular
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,214 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,077 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,108 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
