I was asked for statistics on how much space we're using to store various types of data in SQL Server. Of course I said, “Sure, that'll be easy”. Later, after scratching my head and digging around, I discovered the datalength function. This returns, in bytes, the length of fixed length columns and the actual length of variable length columns.
Print | posted @ Wednesday, February 01, 2006 6:37 PM