http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspxI showed a demo of how to find the top ten tables in the database at the PASS Conference. Here’s that script – you’ll need to fix the server name, instance name, and database name. You can use this to display any numbers – and even more. The mind reelsen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspx#10401561Tue, 12 Mar 2013 12:18:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:10401561Mike Dimmick<p>Answering John Stafford&#39;s question: The SQL Server PowerShell provider is a namespace provider, presenting the SQLSERVER: &#39;drive&#39;. In the example given, UNIVAC is the server name, and DEFAULT the name of the instance (here it was the default instance, which must be specified).</p> <p>To authenticate using a SQL Server login, rather than a Windows login, see <a rel="nofollow" target="_new" href="http://technet.microsoft.com/en-us/library/hh231287.aspx">technet.microsoft.com/.../hh231287.aspx</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10401561" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspx#10170326Wed, 01 Jun 2011 14:55:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:10170326Rowlandg<p>Really enjoyed seeing this at PASS Buck. Nice!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10170326" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspx#10014605Tue, 25 May 2010 12:01:16 GMT91d46819-8472-40ad-a661-2c78acb4018c:10014605John Stafford<p>Having trouble with the DIR command which sets $BigTables - how does this work? I would have thought you&#39;d need to set a sql connection with sqlcmd?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10014605" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2009/11/09/create-an-excel-graph-of-your-big-tables-with-powershell.aspx#10014604Tue, 25 May 2010 12:01:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:10014604John Stafford<p>Having trouble with the DIR command which sets $BigTables - how does this work? I would have thought you&#39;d need to set a sql connection with sqlcmd?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10014604" width="1" height="1">