The Gug (11/2/2015)
Good afternoonI ran across an issue that I don't understand. I have a DB that is 177gb. When I dug through the DB, I found a table that said it had 8gb of data space used and 90gb of index space used. How does that happen?
For future reference, you may find the query in the article below helpful
http://www.sqlservercentral.com/scripts/Index+Size/128428/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉