Folks, I'm loading hundreds of thousands of logging lines into a SQL Server table and I noticed that one of the columns contains only short words taken from a handful of choices. So the column reads like FOO FOO FOO FOO BAR FOO FOO FOO FOO BAR BANG FOO FOO FOO etc. The column will rarely be used.
Would SQL boffins in here consider turning this column into something more space saving, like a single byte flag for example? Perhaps to save space or improve performance. Greg K
