Technical Article

shrinking logs: how much data will be reclaimed

This script will show you how much diskspace can be reclaimed by shrinking all the logfiles of userdatabases using a DBCC SHRINKFILE(2) command. Often the spacegain is much smaller then expected. SQL Shrinks logfiles the end of the file until it finds the active part of the logfile. (If the active part of the logfile […]

2005-03-21 (first published: )

421 reads

Blogs

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Read the latest Blogs

Forums

encrypt the database in azure

By juliava

How can we encrypt the database in Azure. Research story.   Thank you

Shrink database issue

By don075

In my database, I have few temp tables that total up to 50GB in...

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.

By serverdba

Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers