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
Maintenance
Refine your search with one of the following additional tags (with number of items):
T-SQL
(5)
Search
(2)
index
(1)
SQL 2005
(1)
Administration
(3)
T-SQL Aids
(2)
Indexes
(1)
sys.foreign_key_columns
(1)
SQL Server 2005
(3)
Automation
(1)
Search Stored PRocedures
(1)
sys.foreign_keys
(1)
Index Management
(2)
Database Roles
(1)
Security
(1)
sys.sql_modules
(1)
Maintenance and Management
(2)
Fragmentation
(1)
SQL 2000
(1)
Search for
any
content tagged
Maintenance
Add a script
Items 1 to 10 of 10
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
Read more...
By
Augusto Alfonso
2008/09/03
|
Source:
SQLServerCentral.com
|
Category:
Index Management
Rating:
|
Discuss
|
Briefcase
|
59 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
Read more...
By
Jesse Roberge
2008/08/15
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
133 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
Read more...
By
Jesse Roberge
2008/08/29
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
94 reads
Move Physical Files
Script to move physical files to a new location
Read more...
By
Jorge Novo
2008/05/30
|
Source:
SQLServerCentral.com
|
Category:
Maintenance
Rating:
|
Discuss
|
Briefcase
|
708 reads
SQL Server 2005 Index Maintenance
Index maintenance procedure using rebuild or reorganized based on fragementation level.
Read more...
By
Luke C
2008/05/29
|
Source:
SQLServerCentral.com
|
Category:
Maintenance
Rating:
|
Discuss
|
Briefcase
|
248 reads
Set Database to Single user
How to set the database to a single user mode
Read more...
By
Jorge Novo
2008/05/20
|
Source:
SQLServerCentral.com
|
Category:
Maintenance
Rating:
|
Discuss
|
Briefcase
|
647 reads
Identify Large Tables
Reports on physical size of tables in your database to identify largest.
Read more...
By
Jesse McLain
2008/03/13
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
847 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
Read more...
By
Ed Vassie
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
SQL 2000
Rating:
|
Discuss
|
Briefcase
|
886 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
Read more...
By
Boka
2008/01/08
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,209 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
Read more...
By
Boka
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,005 reads
Items 1 to 10 of 10
Most popular
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
Read more...
By
Boka
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,005 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
Read more...
By
Ed Vassie
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
SQL 2000
Rating:
|
Discuss
|
Briefcase
|
886 reads
Identify Large Tables
Reports on physical size of tables in your database to identify largest.
Read more...
By
Jesse McLain
2008/03/13
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
847 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use