Thanks for pointing me to the articles. We're still debating whether to go with the new syntax and non-ANSI SQL, but you added some valuable information.

Just a quick thanks. These updates are always very useful for those of us who don't have time to keep up... Another valuable service of your site!

Another "out there" thought... Have you made sure that nothing else IO intensive is happening on the destination server when the UNC backup is run? Tried scheduling for...

CROSS APPLY -- try it you'll like it! 😀

With Windows Server 2008 (with UAC enabled), you need to grant explicit administrator rights for certain actions even if the user is an administrator. Try opening up the command...

Just caught the question in the recent post. If I can remember my own code correctly:-) The reason the delete of the table variable must happen after the...

Since all the "big guns" are posting on this thread, wonder if I could get some thoughts on a design I am contemplating. We will have multiple sites, multiple...

See the article I posted on this site with an example of using try-catch and an error table.

http://www.sqlservercentral.com/articles/Data+Mart/67606/

Thank you for a very clear and useful article. It provides a good reference to bring to some of those difficult discussions (you know the ones). Now I...

Just as a point of speculation, we might ask why there are so many more young boys than young girls getting lost in the world of video games...

Are you sure that the Windows account you are trying to use has the rights to log on as a service?

Here's a cheerful post back to Jeff -- I totally agree with you that people are overcomplicating many projects by not taking advantage of what the data layer and T-SQL...

Disagreements are good -- better ideas happen that way. One thing I think that Jeff should take more seriously, though, is that some projects may have constraints that disallow...

These posts all have good things to say about considerations when loading data. The example in this article was meant to show a particular way of using sets with...

Thanks for thoughts on dynamic logic to change the size of the sets processed to handle errors. Interesting idea.

While I appreciate the comments on other ways to handle large...