Which edition of SQL Server? (Compression at the page level is awesome for
this but not everyone has it)
I have both SQL Server 2012 standard (for fiddling with), but I mostly use
the previous one, what was it 2008? I haven't heard about the new
compression you mention, so I'll run a few
: http://www.sqldownunder.com/ www.sqldownunder.com
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Wednesday, 26 June 2013 5:53 PM
To: ozDotNet
Subject: Re: Optimising SQL column data
Which edition of SQL Server? (Compression
Hi Greg,
Which edition of SQL Server? (Compression at the page level is awesome for
this but not everyone has it)
It would be really good if the product had a real concept of an enumeration
but it doesn't:
Regards,
Greg
Dr Greg Low
1300SQLSQL (1300 775 775) office | +61
On Wed, Jun 26, 2013 at 3:35 PM, Greg Keogh g...@mira.net wrote:
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