Thank this author by sharing:
By Kenneth Fisher,
I’ve always had a hard time calculating table sizes. So when I first started studying for the 70-450 exam I made a point of printing out the information in books online on the subject. Of course one of the most important parts of calculating table sizes is knowing the size of the different data types and SQL Server 2008 added a large number of new data types. I decided to print out a list of the data types and their storage sizes. Imagine my surprise when I was unable to find a complete list in books on-line. Each data type could be found individually, and there was a general list of data types (with special data types missing). But no single list of the data types, a general description, and a storage size for each. Imagine my further surprise when I couldn’t find a list after several hours of searching on the web. Finally I decided to make my own.
In order to save others some time and grief I am posting my list here. If I’ve missed anything, made any mistakes, or could have included something useful please comment and let me know. I’m still studying and would hate to miss anything in my own documentation, let alone mess up anyone else’s.
maximum length of Dimension Attribute
Extract Number From Alphanumeric Character
find out the customers having maximum number of unique orders.
No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string....
Maximum Number of "When Then" lines in a CASE statement?
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.