Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Shrink Database Rss

   Items 1 to 6 of 6   
 

Shrink Database

By bitbucket-25253 2011/08/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,858 reads

SQL Q&A: Shrinking, Growing and Redesigning Databases

SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.  Read more...
By Additional Articles 2010/08/06 | Source: TechNet Blogs | Category: administration
Rating:  Rate this |   Briefcase | 3,919 reads

Issues with running DBCC SHRINKFILE on your data files

Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.  Read more...
By Additional Articles 2010/07/27 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 4,512 reads

Grow\Shrink all datafiles SQL 2005\2008

Generates a script to grow\shrink all datafiles for a database to the same amount  Read more...
By Allan Roodt 2010/07/23 | Source: SQLServerCentral.com | Category: shrink database
Rating: |  Discuss |   Briefcase | 2,220 reads

Can you shrink your transaction log files to death?

can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.  Read more...
By Additional Articles 2009/02/23 | Source: SearchSQLServer | Category: transaction logs
Rating: (not yet rated)  Rate this |   Briefcase | 3,018 reads

Can you shrink your SQL Server database to death?

To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.  Read more...
By Additional Articles 2008/10/14 | Source: SearchSQLServer | Category: administration
Rating:  Rate this |   Briefcase | 3,895 reads
   Items 1 to 6 of 6   
 
Tags
performance tuning (1)    
transaction logs (1)