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
190 reads
Blogs
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
JSON - What am I doing wrong
Hi, So I'm having a little play with JSON as I need to store...
Using azcopy to copy files
Im trying to copy the contents of my sql server backup .bak files to...
How to efficiently perform search on my DB and Word documents on my server?
So I'm building a system for a client and they want to have a...
Ask SSC