What If You Really DO Need to Shrink a Database?

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.

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

Extended Events

By Michael L John

I have set up an extended event to capture the queries users may be...

Script logins and all permissions: no longer supported in SSMS generate script?

By Maxer

Okay, maybe I've just gone crazy but I was certain it used to be...

Recursive Select runs slow

By Soleya

Hello, I have a recursive Select that runs ultra slow. My test table has...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers