Timeline for Constant values in columns
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 29, 2013 at 6:15 | history | tweeted | twitter.com/#!/StackDBAs/status/372965694989930496 | ||
| Aug 28, 2013 at 20:29 | comment | added | Lorenz Meyer | @jon You're right, this makes no sense. The problem is with my application. I guess I have to look how to modify the application in order to accept a simplified database. It will be kind of a nightmare ... | |
| Aug 28, 2013 at 15:15 | vote | accept | Lorenz Meyer | ||
| Aug 28, 2013 at 14:24 | comment | added | Jon of All Trades | Can you clarify the business goal? I wonder why you'd really always have the same value for every row. The same few values, sure, even one of two for each row, but the same? | |
| Aug 28, 2013 at 14:22 | comment | added | ypercubeᵀᴹ | And SQL-Server 2000 does not have PERSISTED columns, only virtual ones. | |
| Aug 28, 2013 at 14:20 | answer | added | Andriy M | timeline score: 2 | |
| Aug 28, 2013 at 14:18 | answer | added | marc_s | timeline score: 2 | |
| Aug 28, 2013 at 14:16 | comment | added | marc_s |
@a_horse_with_no_name: a computed column is not stored - it's computed every time you access it - unless you specify PERSISTED, then it's persisted like a normal column (and thus doesn't save any space)
|
|
| Aug 28, 2013 at 14:13 | comment | added | marc_s | If you use a normal computed column - then yes, you might save a bit on disk space - BUT always constantly re-computing those values will most likely cost you more in terms of processing time than you save by loading less data | |
| Aug 28, 2013 at 14:03 | history | edited | marc_s | CC BY-SA 3.0 |
deleted 1 characters in body
|
| Aug 28, 2013 at 13:18 | comment | added | ypercubeᵀᴹ | @Lorenz I've edited your question. Please reedit or rollback if I missed your intentions. | |
| Aug 28, 2013 at 13:17 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 30 characters in body; edited tags; edited title
|
| Aug 28, 2013 at 13:07 | comment | added | ypercubeᵀᴹ | I think he means "I'm thinking about replacing them with ..." | |
| Aug 28, 2013 at 12:56 | comment | added | Thronk | "I think about replace the with a constant calculated column" - this line does not make sense to me and maybe your question did not make it into SO as you intended. Could you elaborate? | |
| Aug 28, 2013 at 12:42 | review | First posts | |||
| Aug 28, 2013 at 13:19 | |||||
| Aug 28, 2013 at 12:26 | history | asked | Lorenz Meyer | CC BY-SA 3.0 |