<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
Choose a tag below, or browse popular content:
Administration
Lock and Connection Management
Replication
SQLInsider Scripts
Backup / Restore
Mail
Security
T-SQL
Data Warehouse
Maintenance and Management
SQL Server 2000
T-SQL Aids
Index Management
Miscellaneous
SQL Server 2005
Add a script
Popular Scripts
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
Read more...
By
James Rea
2008/02/11
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
8,236 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
Read more...
By
Absinthe
2008/02/06
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
5,858 reads
SQL Server 2005 - Backup, Integrity Check and Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.
Read more...
By
Ola Hallengren
2008/04/15
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
4,939 reads
Insert Update Stored Procedure for a table
Generic Script for Insert Update Stored Procedures
Read more...
By
Prasad Bhogadi
2007/12/06
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
10,316 reads
Backup SQL Server Database with Move/Copy File
Read more...
By
MD
2007/09/14
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
9,896 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database.
Read more...
By
RBarryYoung
2008/04/08
|
Source:
SQLServerCentral.com
|
Category:
tables
Rating:
|
Discuss
|
Briefcase
|
2,841 reads
Monitor Database Growth
Read more...
By
Brandie Tarvin
2007/05/16
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
9,563 reads
Row count and space used for all tables in database (update)
This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
Read more...
By
Rafal S.
2008/05/02
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,630 reads
Backup Stored Proc
Script to backup 2000/2005 databases.
Read more...
By
Scott Duncan
2008/01/17
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
3,592 reads
Truncate All Tables
Script to Truncate all tables part1
Read more...
By
Jorge Novo
2008/06/03
|
Source:
SQLServerCentral.com
|
Category:
Development
Rating:
|
Discuss
|
Briefcase
|
1,925 reads
Audit SQL Logins - Updated
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.
Read more...
By
Derrick H.
2007/11/28
|
Category:
Audit
Rating:
|
Discuss
|
Briefcase
|
8,197 reads
SQL Server 2005 Remove Dups - CTE
Easily remove duplicate records without temp tables by using a CTE.
Read more...
By
Tom Huneke
2008/05/09
|
Source:
SQLServerCentral.com
|
Category:
CTE
Rating:
|
Discuss
|
Briefcase
|
1,889 reads
usp_KillConnections
Read more...
By
Antonio
0001/01/01
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
6,098 reads
Compare Different tables from 2 Databases
List tables that have different tables and column
Read more...
By
jrtupa
2008/04/07
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
3,103 reads
Auto Auditing on Tables
Read more...
By
Christopher Stobbs
2007/10/03
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
5,970 reads
An easy way to track the growth of your database
This query gives you an idea of the growth of your database over time.
Read more...
By
Sylvia Moestl Vasilik
2008/05/07
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
1,848 reads
Find Column Usage
Read more...
By
kgayda
2007/10/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,057 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
7,131 reads
Get the list of permissions of database object
Read more...
By
Deepthi Viswanathan Nair
2007/09/28
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,996 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,953 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
