Use this and shrunk a 176GB in under 20 secs to 105 MB. Ensure that you understand the potential issues with the recovery of your database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2013-05-06 (first published: 2008-07-21)

13,983 reads

Blogs

it has been a year since i have not written much on the blog...

on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...

I have been active in the data community throughout my career. I have met...

Forums

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

hi, in an ssis for each loop over an object variable called MyListVariable, i...

SQL Server is typically viewed as a transactional or analytical database engine. However, it...

On SQL Server 2025, when I run this, what is returned?

SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')