Q: My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?

(John Savill) A: The first step to try is to shrink the database, which is done through SQL Server Management Studio. Right-click the database, and select Tasks, Shrink Database, as the screen shot shows below.

Read More - Register for Free Membership