<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>
Content with tag
maintenance
<< Newer
Items 21 to 40 of 89
Older >>
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,098 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,539 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
|
836 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,015 reads
Identify Large Tables
Reports on physical size of tables in your database to identify largest.
Read more...
By
Jesse McLain
2012/03/26
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,132 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
Read more...
By
Boka
2012/01/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,586 reads
SQL Server 2005 Index Maintenance
Index maintenance procedure using rebuild or reorganized based on fragementation level.
Read more...
By
Luke Campbell
2011/10/26
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
3,310 reads
Next grow for all databases per disk
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
Read more...
By
Gonzalo Moles
2011/10/11
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
959 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
2011/09/08
|
Source:
SQLServerCentral.com
|
Category:
sql server 7
Rating:
|
Discuss
|
Briefcase
|
5,011 reads
List all tables without LOB columns
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.
Read more...
By
SQLSACT
2011/08/30
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
697 reads
Automate drive space monitoring for all production servers
Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it
Read more...
By
Roshan Joe Joseph
2011/04/19
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,649 reads
Reindex all indexes online or offline depending on day of week.
This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
Read more...
By
Kenneth Singer
2011/04/18
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
4,371 reads
Automatic Statistics Update Slows Down SQL Server 2005
I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.
Read more...
By
Additional Articles
2011/02/25
|
Source:
MSSQLTips.com
|
Category:
maintenance
Rating:
(not yet rated)
Rate this
|
Briefcase
|
4,573 reads
Index defrag script (21005/2008)
This script will allow reindexing (either rebuild or reorg)
Read more...
By
Gregory Ferdinandsen
2010/08/25
|
Source:
SQLServerCentral.com
|
Category:
reindex
Rating:
|
Discuss
|
Briefcase
|
3,215 reads
Index usage overview
This view reports almost everything you want to know about your indexes
Read more...
By
Wilfred van Dijk
2010/06/09
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,718 reads
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
2010/05/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,495 reads
Retrieve Default SQL Server Backup Folder using PowerShell
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
Read more...
By
Additional Articles
2010/04/23
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,970 reads
Index usage overview
This view reports almost everything you want to know about your indexes
Read more...
By
Wilfred van Dijk
2010/06/09
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
|
Discuss
|
Briefcase
|
3,718 reads
Shrink Database Files in Size Increments
Auto shrink database files in size increment to a desired file size.
Read more...
By
Boris Moyse
2010/03/02
|
Source:
SQLServerCentral.com
|
Category:
maintenance
Rating:
|
Discuss
|
Briefcase
|
2,199 reads
Catching errors in DBCC CHECKDB
Read more...
By
Jesse Reich
2009/11/04
|
Category:
maintenance
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,334 reads
<< Newer
Items 21 to 40 of 89
Older >>
Tags
administration
(25)
sql server 2005
(21)
t-sql
(21)
indexing
(20)
maintenance and management
(20)
utility
(16)
performance tuning
(11)
automated dba
(7)
storage
(7)
sys.dm_db_partition_stats
(7)
backup / restore
(5)
list indexes
(5)
pivot
(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)
space usage
(3)
sql server 7
(3)
automation
(2)
buffer cache
(2)
database roles
(2)
fragmentation
(2)
lock and connection management
(2)
search
(2)
statistics
(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)
archive
(1)
career
(1)
consulting
(1)
cursor
(1)
data integrity
(1)
data quality
(1)
database mail
(1)
dbcc checkdb
(1)
defragment
(1)
delete
(1)
development
(1)
disk space
(1)
duplicate indexes
(1)
dynamic management function
(1)
dynamic management view
(1)
dynamic sql
(1)
foreign keys (fk)
(1)
growth trend
(1)
indexes
(1)
kill connections
(1)
kill sessions
(1)
list scheduled jobs
(1)
log file maintenance
(1)
maintenance plans
(1)
management
(1)
missing indexes
(1)
powershell
(1)
rebuilding indexes
(1)
reindex
(1)
report
(1)
resource planning
(1)
running aggregate
(1)
running totals
(1)
security
(1)
selectivity
(1)
space
(1)
sql server 2008
(1)
staging
(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 variables
(1)
tuning
(1)
xp_cmdshell
(1)
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
