Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TheLittleSeeker

  1. TheLittleSeeker

    Table Size Query

    Hi All, I've managed to solve the questions that I've posted earlier. Thank you for your help and support. Have a nice day. Bye
  2. TheLittleSeeker

    Table Size Query

    Hi Olaf, Thank you very much for your response and help. It had cleared my doubt and the given article is very useful. If it's not too much too ask, would like to check on the following 2 items: 1) Would it be possible to have below sql statement (SAMPLE 2) coded into SQLCMD command and...
  3. TheLittleSeeker

    Table Size Query

    Hi Olaf, declare @TableSpace table (TableName sysname, RowsK varchar(32), ReservedMB varchar(32), DataMB varchar(32), IndexSizeMB varchar(32), UnusedMB varchar(32)) Insert into @TableSpace exec sp_spaceused 'Production.BillOfMaterials'; Select * from @TableSpace Can I check what does...
  4. TheLittleSeeker

    Table Size Query

    Hi Olaf, Thanks for your response and help. I'll do further testing with your method. Thanks.
  5. TheLittleSeeker

    Table Size Query

    Hi Olaf, Thanks for your response and help. I've tried something like this, but it does not working. declare @tablespace table (TableName sysname, RowsK varchar(32), ReservedMB varchar(32), DataMB varchar(32), IndexSizeMB varchar(32), UnusedMB varchar(32)) insert into @tablespace exec...
  6. TheLittleSeeker

    Table Size Query

    Hi Olaf, Thanks for your response and help. Could you help on how can I use commands "sp_MSforeachtable" and "sp_spaceused" to check only for these selected tables: EMP001, EMP002, EMP003, EMP004, EMP005 ? Appreciate for your help. Thanks.
  7. TheLittleSeeker

    Table Size Query

    Hi Experts, I'm using Ms SQL Server 2008 R2 (Enterprise edition), I need some help in compiling the correct SQL query to check table size of certain tables. There are plenty of examples from forums on checking for all tables, however, this is not what I'm looking for. Let's say I've the...
See more

Part and Inventory Search

Back
Top