We are having the same issue with FULL backups as well as Differentials. It seems to occationally reoccur on the same databases but mostly seems random.

TCP Provider: The semaphore...

I'm really starting to hate April Fools Day...

Real Nice! What a disappointment for all us DB geeks!!

I'll be checking this app out.  It looks great!

Todd, let me make sure that I understand your senario before I post an answer.  Am I right in saying that you have Parent table A which can or does...

I am really glad that a the conversation on this topic is continuing and that people are pointing out differences in results, and yes my typo's too. 

Looking back at...

Just out of curiosity, what does the SQL Server error log tell you about the attempted restore.  Also check the Event log for any errors at that time.

It could be...

Great!  Thanks Charles I'll take a look.

Rick you are right about Test5 (see below for Test6 comments) the (open-write-close) does contribute to all of the additional overhead there, and it really isn't a valid comparison to...

Mike, thanks for the responce.  The goal of the article was more to identify the performance factor involved in the use of the sp_oa extended procs and using it and...

yah I feel stupid now, sorry guys I didnt see those posts above I was just posting to the last comment.  And by the way I think CJohnson has a...

Often you can add a new column to the end of the table and people can want it in a different location because they use SELECT *, and they want...

Get rid of your use of functions in the join clause.  You could consider doing your rounding, converting and getdate to variables before hand and then use the variable values there....

First thing I would do is look for a unique candidate that exists in the table before you go this route.  I will give you possiblities but, the reason you...

You can always use the xp_msver system extended stored proc.