sqlsunday.com

T-SQL programming, useful tips and tutorials for the MS SQL Server developer.

Skip to content
  • Newsletter
  • About sqlsunday.com
  • Structured Concepts
    • Master data tool
    • File parser API
  • Slack app
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Links and utilities
Search

mb

Viewing the size of your database objects

2014-10-052014-08-01 / Daniel Hutmacher / Leave a comment

Here’s a practical script that I built to view how much space each database object takes up in the database. The script also show you information on how many rows a table (or indexed view) contains, as well as if it’s partitioned and/or compressed.

Continue reading →

Categories

  • By difficulty (175)
    • Advanced (38)
    • Basics (50)
    • Intermediate (89)
  • CLR (1)
  • Off-topic (13)
  • Rant (5)
  • Scripts (19)
  • Series (29)
    • Efficient data (8)
    • Introduction to T-SQL (1)
    • Slowly changing dimensions (5)
    • SQL Server security (15)
  • SQL Server concepts (74)
  • T-SQL (126)
  • Tips (50)
  • Uncategorized (1)
  • Videos (2)

Search for articles

Create a website or blog at WordPress.com