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

Blogs

Daily Coping 5 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 4 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What’s next III

By

In case you didn’t know I was given notice about a month and a...

Read the latest Blogs

Forums

Use 2 CTEs in a Single SQL Query

By gjoelson 29755

Hi , I'm trying to union 2 CTE queries into one.  but must be...

Business Analytics from Application Logs and SQL Server Database using Splunk

By roopesh.uniyal@gmail.com

Comments posted to this topic are about the item Business Analytics from Application Logs...

DATETRUNC

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DATETRUNC

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers