Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snomad
Starting Member
22 Posts |
 Posted - 2009-09-30 : 08:28:49
|
Hi guys, I am in need of your brains!! Appreciate any advice here!! Ye shall be rewarded with good karma.Is there any reason at all that a shrink db would improve performance? Client has been told that we should schedule a shrink in. As far as I can see, this will only hinder performance.Space on the box is not an issue - it's purely a performance question. Thank you!! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-30 : 10:06:42
|
| [url]http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/[/url][url]http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/[/url][url]http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx[/url][url]http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.aspx[/url]--Gail ShawSQL Server MVP |
 |
|
|
snomad
Starting Member
22 Posts |
Posted - 2009-09-30 : 11:18:07
|
| Cheers. Sorry, should have googled more thoroughly first. ;)Thank you!! |
|
|
|
|
|
|
dbcc shrinkdb