That's good to know. We were doing it for performance reasons, not because of failures in the code, but if we dodged a bullet, so much the better.

"can we also use a path where the XML file exists."

I'm pretty sure that you can't reference files directly from within TSQL. If you really, really HAD to do...

Nice article.

You might consider adding information about performance management. For example, maintaining the document handle across multiple queries and/or procedure calls is pretty expensive. Generally, if we run into a...

We've been using SQL Data Compare for a couple of years and SQL Compare for just over a year and we've been extremely happy with the tools. Further, we're happy...

By the way, the title of this article is misleading. I expected to see something about natural versus artificial keys, unique constraints, resolving sub-type roll-ups, logical arcs, denormalization by design,...

Naming standards are very good things. Common abbreviations are very good things.

Very good things can, however, be taken to silly extremes. We've got a logical modeling team tasked with, along with...

Thanks for the input. We are going to look at dbGhost since we're in the process of reworking how we do our development and QA processes and planning on working...

I very much enjoyed the article. I sent it on to our team because we've had this debate internally several times.

That said, a few bones to pick...

It is a bit...

Great topic.

I look forward to seeing the details of how you implement your changes. We've been working with a change management process, that takes into account the issues you raised,...

One reason, indexes on heap tables are forced to use the physical storage location of the data. Any page splits in the data itself will cause a cascade to any...