Home Forums SQL Server 2008 SQL Server 2008 Administration Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion RE: Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion

  • I found out that this data file contains data from a text column.

    Could this be the reason I am having trouble shrinking the file?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]