I would disagree with TINYINT: I knew that TINYINT was the intended answer, but intentionally chose SMALLINT.  The reason has to do...

Just out of curiosity, how much does the API server software cost?  I went to the site you linked, and noticed that...

Nice article, thanks for sharing. We have a number of systems that have some high “peakedness” for CPU. It hasn’t become an issue yet, but I’ll look into...

I think the editorial was good. It put into words some of the thoughts I’ve had for a while, especially in the area of schemaless schema (EAV). If...

Yeah, the good old days…

In the past I did a lot of work on Solaris / UNIX systems to extract data and prepare it for database loading. I...

Regarding emails (at work), I create an annual PST file. As I get the periodic “do you want to archive” I move anything I received or sent for a...

Interesting article; thanks for writing it.

I work a lot with dimensional data warehouses, and use SP’s for all of my ETL work. I do logging very similar to this:...

So long, and thanks for all the fish.

Jeff Moden (4/22/2015)

DEK46656 has the right idea and he also has the right idea of splitting this thing into obvious paired parts but most people don't understand even the straight...

Curious problem… the first thing I thought of was to think of the format (AA00ZZ99) as an IP address: split up the value into 4 distinct buckets, with a numeric...

Agreed. I've been to his site a lot in my attempts to learn.

Though I have known about Service Broker since its initial release, I never had a reason or chance to work with it… until recently. I am trying to push...

A couple of other folks mentioned this already, but I can definitely see it: R#

Think about it; C#, ADO.NET, and R# all working together…

Something I'm guilty of is a comment like this:

-- If you get to this point, you have problems

This is what I've seen most.