title: How to find the total tablespace usage in SQL Server 2008?
body: <p>In SQL-server 2008, How would I find (through an SQL query), the percentage of tablespace usage for a particular instance(or all instances) of a SQL Server(2008 R2)?</p>
  
  <p>Also, what is the best way (query) to get the list of all the Named Instances of a SQL Server?</p>