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
Blogs
VMworld 2020 SQL Server session preview
By kleegeek
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by...
Azure Synapse Analytics overlooked features
By James-Serra
There are some options in Azure Synapse Analytics that are not obvious that I...
Forums
SQL Agent error history
Is there a way to capture 2 things, when did the job failed and...
Import csv file into existing table where 1st row has sep=,
Hi, I have a csv file that has the value "sep=," in the first...
Inserts not propagated in transactional replication
Hello, I have a transactional replication configured which subscription fails to sync to often...
Ask SSC