Hey slick, I think your approach is my favorite then. Cool beans!

I was thinking about this some more and I would expect that the DB must deserialize each value from the varbinary storage to your UDT representation to check equality. Unless...

How does this work when you want to filter on a given IP or subnet? Does the UDT have to be deserialized for every row to compare, or does sql...

And to your original question - I run a similar config although with poor man's log shipping, I run some code to do log restores to my warm Express SKU...

You may want to consult Books Online:

http://msdn2.microsoft.com/en-us/library/ms189085.aspx

It states that a full backup truncates the log if you are using simple recovery, and that it does not truncate the...

If you have humans running a lot of adhoc queries, I suppose not normalizing out your state abbreviations is worthwhile. If you have a heavy query load running over a...

I'm not sure I see the need to have the data be human readable. I guess it depends on the specifics of your use case.

My assumption is that the index...