<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
Databases
Search for
any
content tagged
databases
Add a script
Items 1 to 12 of 12
Smart Index Rebuild - All Databases
Rebuilds all indexes from all databases over a specified fragmentation threshold.
Read more...
By
Tim Hollobon
2012/11/08
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
1,657 reads
Relationship between users and Databases
Show the users inside the databases
Read more...
By
Ricardo Leka
2011/05/30
|
Source:
SQLServerCentral.com
|
Category:
user
Rating:
|
Discuss
|
Briefcase
|
2,087 reads
How to output datafiles location using sp_helpdb?
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
Read more...
By
anthonyszm
2010/07/02
|
Source:
SQLServerCentral.com
|
Category:
sp_helpdb
Rating:
|
Discuss
|
Briefcase
|
1,185 reads
Track database growth
Script to keep track your database growth - Works with SQL 2000, 2005 & 2008
Read more...
By
Irwan Tjanterik
2011/07/19
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
6,332 reads
Find information about all databases
ALL database information
Read more...
By
umar iqbal
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
1,839 reads
Database Growth History
This script uses the backup tables to get info on the growth of your database files.
Read more...
By
Nicholas Williams
2013/05/07
|
Source:
SQLServerCentral.com
|
Category:
growth
Rating:
|
Discuss
|
Briefcase
|
4,260 reads
how get primary key in any database
drop the primary key name is different for each database
Read more...
By
Furanshizuku
2009/01/29
|
Source:
SQLServerCentral.com
|
Category:
primary key (pk)
Rating:
|
Discuss
|
Briefcase
|
1,233 reads
Growth remaining for SQL Server 2005 databases
This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.
Read more...
By
Mahidhar Vattem
2009/01/30
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
845 reads
How to Drop Unused Empty Redundant columns
Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns
Read more...
By
Chris Morton
2008/11/27
|
Source:
SQLServerCentral.com
|
Category:
alter table
Rating:
|
Discuss
|
Briefcase
|
1,119 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
10,795 reads
How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
Read more...
By
Tariq
2013/05/19
|
Source:
SQLServerCentral.com
|
Category:
system stored procedure
Rating:
|
Discuss
|
Briefcase
|
700 reads
Set standard database options
Ensure all your databases have standardised options by running this script weekly.
Read more...
By
Ed Vassie
2011/09/19
|
Source:
SQLServerCentral.com
|
Category:
sql server 7
Rating:
|
Discuss
|
Briefcase
|
2,026 reads
Items 1 to 12 of 12
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
