Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL When is too many columns too many columns? RE: When is too many columns too many columns?

  • February 1, 2018 at 3:25 pm

    #1978277

    Grant Fritchey - Tuesday, January 16, 2018 6:13 AM

    The whole "flat tables are faster" myth makes me insane. It generally comes from "flat tables are faster than my horrifically bad normalization/poor choice in fact table definition." Yes, writing mediocre code runs faster than writing bad code. Well done. What if we actually write good code?

    I'm 100% going to use this as I came across a table today with 1060 columns... 

    I think if I recommend abandoning our RDBMS for a flat file system my mugshot will end up on a wall with the title of "wanted dead or alive".