Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Content with tag
Maintenance
<< Newer
Items 21 to 40 of 105
Older >>
The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
Read more...
By
Jesse Roberge
2013/07/17
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,699 reads
Custom Maintenance Plans - the T-SQL way
The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
Read more...
By
Mark Marinovic
2013/05/16
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
3,602 reads
Check Candidate Columns for FOREIGN KEY Constraints
Reports table columns that are not foreign keys but that perhaps should be.
Read more...
By
Charles Jacobus
2013/04/23
|
Source:
SQLServerCentral.com
|
Category:
maintenance
|
SQL Scripts Manager Compatible
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
859 reads
Identify Obsolete Indexes
Drop indexes no longer being used.
Read more...
By
Chad Churchwell
2013/03/08
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,210 reads
Objects Referenced and Referencing
This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.
Read more...
By
Charles Jacobus
2013/03/07
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
841 reads
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
Read more...
By
Andrew Pruski
2013/02/19
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
2,054 reads
Check Candidate Columns for NOT NULL Constraints
This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.
Read more...
By
Charles Jacobus
2013/01/23
|
Source:
SQLServerCentral.com
|
Category:
data integrity
Rating:
|
Discuss
|
Briefcase
|
690 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
Read more...
By
Grant Fritchey
2013/01/11
|
Source:
SQLServerCentral.com
|
Category:
fragmentation
Rating:
|
Discuss
|
Briefcase
|
2,536 reads
Defragmenting and rebuilding indexes
Following code snippet will selectively rebuild indexes that have been thrashed after a big indert
Read more...
By
Cool
2013/01/09
|
Source:
SQLServerCentral.com
|
Category:
rebuilding indexes
Rating:
|
Discuss
|
Briefcase
|
3,307 reads
The Ultimate Missing Index Finder
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
Read more...
By
Jesse Roberge
2013/01/07
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
19,110 reads
The Ultimate Index Usage Reporter
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
Read more...
By
Jesse Roberge
2012/12/27
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
7,644 reads
Get Scheduled Jobs from Multiple Servers
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
Read more...
By
Dean Castro
2012/12/06
|
Source:
SQLServerCentral.com
|
Category:
list scheduled jobs
Rating:
|
Discuss
|
Briefcase
|
886 reads
Find Mismatched Views and Stored Procs
Find missing and mismatched views and stored procs between 2 Databases
Read more...
By
Pratap Prabhu
2012/09/03
|
Source:
SQLServerCentral.com
|
Category:
development
Rating:
|
Discuss
|
Briefcase
|
1,542 reads
2008 Index Rebuild using DMV
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
Read more...
By
Tommy Bollhofer
2012/08/09
|
Source:
SQLServerCentral.com
|
Category:
indexing
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,606 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
Read more...
By
Brandie Tarvin
2012/07/24
|
Source:
SQLServerCentral.com
|
Category:
database roles
Rating:
|
Discuss
|
Briefcase
|
1,342 reads
Developing Low-Maintenance Databases
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
Read more...
By
Additional Articles
2012/07/23
|
Source:
SimpleTalk
|
Category:
maintenance
Rating:
Rate this
|
Briefcase
|
3,931 reads
Set Database to Single user
How to set the database to a single user mode
Read more...
By
Jorge Novo-@ETLDEVDBA
2012/07/13
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
2,161 reads
Total Space Used for all databases per disk
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
Read more...
By
Gonzalo Moles
2014/01/08
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
3,885 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
Read more...
By
Dmitriy Ivanov
2012/04/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
878 reads
Move Physical Files
Script to move physical files to a new location
Read more...
By
Jorge Novo-@ETLDEVDBA
2012/03/30
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
3,167 reads
<< Newer
Items 21 to 40 of 105
Older >>
Tags
administration
(26)
indexing
(24)
sql server 2005
(21)
t-sql
(21)
maintenance and management
(20)
utility
(16)
performance tuning
(11)
automated dba
(7)
storage
(7)
sys.dm_db_partition_stats
(7)
backup and restore
(5)
list indexes
(5)
pivot
(5)
powershell
(5)
auto-growth
(4)
crosstab
(4)
data file management
(4)
for xml path
(4)
routine database growth
(4)
routine growth
(4)
sys.allocation_units
(4)
backups
(3)
space usage
(3)
sql server 7
(3)
automation
(2)
buffer cache
(2)
database roles
(2)
dynamic sql
(2)
fragmentation
(2)
lock and connection management
(2)
report
(2)
search
(2)
statistics (data)
(2)
sys.dm_exec_query_plan
(2)
sys.dm_exec_requests
(2)
sys.dm_exec_sessions
(2)
sys.dm_exec_sql_text
(2)
sys.dm_os_buffer_descriptors
(2)
sys.partitions
(2)
troubleshooting
(2)
aggregates
(1)
alerts
(1)
always on
(1)
archiving data
(1)
blogs
(1)
career
(1)
consulting
(1)
cursors
(1)
data
(1)
data integrity
(1)
data management view
(1)
data quality
(1)
database mail
(1)
dbcc checkdb
(1)
defragment
(1)
delete
(1)
development
(1)
disk space
(1)
dmv
(1)
duplicate indexes
(1)
dynamic management function
(1)
dynamic management view
(1)
foreign keys (fk)
(1)
growth trend
(1)
heaps
(1)
html
(1)
kill connections
(1)
kill sessions
(1)
list scheduled jobs
(1)
log file maintenance
(1)
maintenance plans
(1)
management
(1)
missing indexes
(1)
old files
(1)
plans
(1)
press release
(1)
purge
(1)
rebuild
(1)
rebuilding indexes
(1)
reindex
(1)
resource planning
(1)
running aggregate
(1)
running totals
(1)
security
(1)
selectivity
(1)
space
(1)
sql server 2008
(1)
staging
(1)
stairway series
(1)
sys.dm_db_index_usage_stats
(1)
sys.dm_db_missing_index_details
(1)
sys.dm_exec_connections
(1)
sys.dm_exec_cursors
(1)
sys.dm_tran_session_transactions
(1)
sys.foreign_key_columns
(1)
sys.foreign_keys
(1)
sys.sql_modules
(1)
system view
(1)
table
(1)
table variables
(1)
tuning
(1)
update statistics
(1)
xp_cmdshell
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.