Constant values in columns
1
vote
2
answers
3259
views
I have a SQL Server 2000 database used by our ERP system.
There are many columns that always have the same value. A table row is really huge, potentially exceeding the maximum row size in SQL Server 2000 (8kB).
I'm thinking about replacing these columns with constant calculated columns. This should decrease the size of the table. I expect better performance, because there is less data to read from disk, when the server needs to load the table in memory.
Is this a good idea ? Will I obtain the expected performance gain ?
Asked by Lorenz Meyer
(153 rep)
Aug 28, 2013, 12:26 PM
Last activity: Sep 10, 2013, 12:44 PM
Last activity: Sep 10, 2013, 12:44 PM