Skip to content
  • Home
  • About

SQL-PLAY

Tips and tricks on SQL Server and not only

Tag: tables

Tables and space used by them

Posted on April 28, 2011April 28, 2011 by Calin OPREA

This came up when a dear colleague of mine came to her boss and told him that even though the table she just created had only one row, "is taking up much more space than needed" – this is the actual quote. Let see what she meant. CREATE TABLE dbo.Table_1 ( large_column CHAR(8000) NULL ) … Continue reading Tables and space used by them →

Tagged heaps, structure, tablesLeave a comment

Categories

  • aws (1)
  • books (2)
  • bugs (2)
  • choice (2)
  • data types (1)
  • general troubleshooting (10)
  • hardware (2)
  • installation tips (8)
  • multi-az (1)
  • performance tuning (2)
  • physical design (1)
  • rds (1)
  • structures (1)
  • tips (1)
  • Uncategorized (26)
Blog at WordPress.com.
  • Follow Following
    • SQL-PLAY
    • Already have a WordPress.com account? Log in now.
    • SQL-PLAY
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar