To my point - if you are using datetime or datetime2 and need to be accurate across time zones, then you must have some method of determining the...

To my point - if you are using datetime or datetime2 and need to be accurate across time zones, then you must have some method of determining the offset at...

It's easier to change your job title than to improve your skill set 😛

The difference between a datetime vs a datetime2 for this seems not very relevant for just capturing entry date the precision difference between the two is within the margin of...

We can agree to disagree - but let me ask you this: How can you determine which entry in your table was entered in New York - and how...

 It is simply true. Good database design actually frees developers from enforcing data integrity and similar database stuff.

This is only partially true, database constraints can prevent bad data from getting...

I want intellisense to work consistently.....

And when there's a column overflow/truncation the error message should include the freaking column name.....

BCP supporting database to database transfer so I don't have to...

Because a field has nulls in it.

Why are you joining on row number?  How many rows will that actually match?

Do the order by on the guid.

You don't have an order by on your join query so they're returning rows in different orders, try ordering that by maybe the guid and see what you get 🙂

Sure, this is pretty common when you use it with a meaningful order by. ...

That seems to be some custom SSIS component you're using, it's entirely possible it's not optimized properly. Have you tried just generating the XML in SQL Server with XML...

Those are all good points in favor of using stored procedures.  Something else to consider though is who is in charge of creating reports?  What permissions do they have in...

I find it odd that they would build such encoding into XML without building in some "old fashioned" coding to handle things like integers and dates without the bloat of...