Interests: My true passion are my kids and supporting the local music scene in Jacksonville, Florida. I am also the President and Founder of a non-profit corporation that supports the local music scene in Jacksonville and North Florida.

Shrink Multi-File Databases

by Larry-Briscoe

SQLServerCentral

Maintenance and Management

This stored procedure shrinks all database files within the current database, including the unused portion of transaction log. This procedure is especially useful for multi-file databases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-03-24

198 reads

Discuss

Blogs

Small Data SF 2024

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

Being an extroverted introvert at a conference

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Being an extroverted introvert at...

Need to group the same valued ID fields to run an aggregate average over them

I have data that contains poll results, with the poll_id consistuting a single row...

SSIS Question

Hi everyone. I am re-writing a portion of my SSIS logic. My SSIS package...

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers