It's a little outdated, but I wrote the source control chapters on this book on Team Development. It covers some of what you're looking for. Also, my company, Red Gate...

Do you have enforced referential constraints on the columns you're joining on? Does the data accurately map between the two tables, or is it possible that you're getting multiple matches...

No, you can't insert data into a table without some locking being applied. That's all part of the ACID properties of a relational database. You can look at trying out...

It sounds like bad parameter sniffing. What's likely happening is that a query is getting an execution plan that doesn't work well for most data sets, that's causing issues, you...

You can use the transaction log backups from log shipping in a recovery scenario.

I hadn't heard, but now that I know... I'm bummed. They made the show really fun.

GilaMonster (8/22/2014)

There's the problem.

Take that filter out, the event will then show up and you...

You should absolutely see a command like:

SELECT * FROM HumanResources.vEmployee AS ve

within a server side trace if you're capturing SQL:BatchStarting. The only reason you wouldn't see that command is because...

If you're doing log shipping, by definition you're backing up the transaction logs. That's how you can move them to another location.

Full backups and log backups, after the very first log backup, are not in any way connected. You're safe to take those backups. Now, if you start introducing differential backups,...

Yep, go to your backups. That's the safest road to recovery here.

And I was thinking the opposite, that the T-SQL would be under the user account while the GUI would be otherwise.

It sounds like a security problem. The GUI works just fine in 2012 (not that I use it or advocate for it). Access denied is a very specific error suggesting...

Sounds like it might be fixed, but if not, no, you shouldn't need to update statistics. When you create an index for the first time, and same thing goes for...

I would suggest looking at the wait statistics by querying sys.dm_os_wait_stats before and after you run your query in order to understand why things are running slowly. I'd also look...