Most of these methods don't correctly handle situations where the final value is null (leaving a trailing comma).  It's simpler to handle this using leading commas rather than trailing...

I wish MS would stop...

Ah......

Awesome.  Thanks for the tips on the use of Crucible.

As far as losing comments in our VCS goes, we don't.  What we are going to lose is ALL of the...

I guess I just don't understand why anyone would do such a thing.

For deployments, it's easier to go with a script.

For documentation, it's easier to go with what SQL Server...

Heh... good comments both simplify and rule the world.  It's too bad that people don't understand that comments external to the code, even in a VCS, are too easily lost. ...

Use a Tally Table...

For those who may be lurking on this thread and possibly not understanding how the code on this thread works, especially with the most recent corrections submitted by DesNorton above,...

Check the usage on the heaps.  If they're not being used, don't worry about their fragmentation.

Enquiring minds want to know... with a monster system like what you have, why are you "cheaping out" with Standard Edition especially when you expect so many simultaneous connections?

So, a new employee is promoting the idea of migrating from T-SQL to Python with Pandas.  The existing code base is a large set of calculations (hundreds) done using...

Where others use variations of "foobar" for things they can't think of a name for, I use variations of "noddy". You're not...

I have a database which is partitioned.  Part of maintenance for a particular table is to switch a partition to another table in order to remove the unwanted oldest...

> my problem is that some positions have the max salary listed as hourly rate and some are annual amount. Therefore,  I need to multiply the hourly rate by...

6 if...