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
195 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
Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather,...
Daily Coping 1 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Building a pacemaker cluster to deploy a SQL Server availability group in Azure
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL...
Forums
Help with Column Visibility Expressions
I have a parameter in my report labeled as PaySource. PaySource has 3 values...
SQL Server and CloudStrike
Has anyone had issues with CloudStrike Anti-Virus on their SQL Servers? I've had a...
Table Date field format
I created a date field [Datte] in SQL v2008. I then link with MS...
Ask SSC