InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:21:49 GMT20http://www.sqlservercentral.com/Forums/Topic404596-748-1.aspxWhy do you use KiloBits for your labels (Kb), when you are calculating KiloBytes (KB)? Capitalization matters, since it changes the meaning.Tue, 08 Jan 2008 12:44:14 GMTPhilPachahttp://www.sqlservercentral.com/Forums/Topic404596-748-1.aspxHi.. this is how I got a proc to run on all dbs you need to create the proc from the statement(s) on each database (using your standard distribution methods I assume - if you know how to do this please let me know - just learning)[i]Create procedure indexlistasselect db_name() 'DataBase',object_name(x.id) tblnm,x.name 'index name', --rest of queryorder by IndexSizeKb desc go[/i]Then you can use sp_MSforeachdb such as.....EXEC sp_MSforeachdb @command1 = "Use ? Exec indexlist"Wed, 05 Dec 2007 12:20:25 GMTtoniupstnyhttp://www.sqlservercentral.com/Forums/Topic404596-748-1.aspxGetting Sizes for Each Index...I borrowed the concept to create a script to get size of each index instead of size of all indexes for the table./* Get tablename, tableid, index name, index id and size in KB(descending) of all indexes for the User tables *//* Toni M. */select object_name(x.id) 'table name', x.id 'table id',x.name 'index name', x.indid 'index id', ((x.used * 8192.00)/1024) IndexSizeKbfrom sysindexes xwhere Substring(x.name,1,7) &lt;&gt; '_WA_SYS' -- do not include statisticsand x.indid not in (0,255) and -- not a table or TEXT/IMAGEexists(Select type from sysobjects o where o.name = object_name(x.id) -- table name for index and o.type='U' ) -- user tableorder by IndexSizeKb desc Wed, 05 Dec 2007 09:46:17 GMTtoniupstnyhttp://www.sqlservercentral.com/Forums/Topic404596-748-1.aspxI like it, but I've got a situation where I want to get it for each db in my instance. I've tried using the sp_MSforeachdb but can't seem to get it working? I've also included the db_name() function so that I can get the full list... Any help would be appreciatedFri, 30 Nov 2007 07:28:09 GMTStevie Thttp://www.sqlservercentral.com/Forums/Topic404596-748-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Administration/61183/">Show Table, Index and Image/Text size.</A>[/B]Sat, 29 Sep 2007 22:45:15 GMTEder F Dias