Database Administration

External Article

What If You Really DO Need to Shrink a Database?

  • Article

You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well just leave the space there, because you’re gonna end up using it anyway.

2020-07-29

SQLServerCentral Editorial

An Alert Philosophy

  • Editorial

Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]

You rated this post out of 5. Change rating

2019-06-19

234 reads

Blogs

Summit Launch Pricing Ends June 7

By

The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....

Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data

By

Information security and privacy are key in today’s data-driven world. Sensitive data needs to...

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices

By

 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a...

Read the latest Blogs

Forums

Not wanting to use a Cursor, but...

By jwilkerson@valleymetro.org

Ok, need someone to talk me off the cursor ledge on this one. I...

Better Communication Through Less Messaging

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Communication Through Less Messaging

MuleSoft Integration with Azure Key Vault

By Sukanya Konatam

Comments posted to this topic are about the item MuleSoft Integration with Azure Key...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers