Showing posts with label SQL Server. Show all posts

As a DBA must pay attention to the hard disk space used by the table. Here's how to display the disk space used by the table. Open SQ...

As a DBA must pay attention to the hard disk space used by the table. Here's how to display the disk space used by the table.
  1. Open SQL Server Management Studio
  2. Choose database
  3. Click on New Query
  4. Type command EXEC sp_msforeachtable @command1="exec sp_spaceused '?'"
  5. Execute query

Have a nice day...