Shrink Multi-File Databases
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.
2003-03-24
191 reads
- 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.
Blogs
Captioning Options for Your Online Conference
Many conferences have moved online this year due to the pandemic, and many attendees...
Power BI – Hungry Median
Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...
Top 10 Must-Ask Questions Before Going to the Cloud
By kleegeek
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...
Forums
Variable Based on Variable in Paginated Report w/ Native Oracle Connection
I have an SSRS paginated report where users need the ability to pick and...
IndicatorsPool events causing memory pressure?
Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...
Sql Server Specs Question
Hi, I have two different servers that I do a bulk insert on the...
Ask SSC