Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Disk Is Cheap! ORLY? RE: Disk Is Cheap! ORLY?

  • November 5, 2012 at 7:42 am

    #1556053

    Jeff Moden (10/5/2012)

    Solomon,

    I've recently had the need to refer to this article again and I thank you from the bottom of my heart. This "right sizing on steroids" article should be required reading for anyone and everyone who has or will ever write the words CREATE TABLE. My hat is off to you, good Sir. Well done!

    Hi Jeff and thank you very much for such positive feedback. I apologize for the delayed response but new baby came along less than 2 weeks before your comment and things have been, well, C-R-A-Z-Y!! :hehe: Also, I had thought of a few minor additions to make and wanted to get them in and published before replying.

    I have added:

    • A reference to decreased Page Life Expectancy in the paragraph about memory usage
    • Info about several other datatypes at the end of the main recommendations list, things like: SMALLMONEY, REAL, TIME, etc.
    • Info about some newer features that can help save space in addition to (not in place of) a good model. Namely: SPARSE columns and Row / Page compression

    Hopefully the updates make for an even stronger article :-).

    Take care,

    Solomon...

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR