It's very likely a permissions issue. When you run backups through SQL Agent, for example, that backup process is running under SQL Agent's login, whatever that might be. When you're...

So, general advice, not specifics.

Measure the performance of each of these systems. Get the wait statistics and break that down by database. Best way to do this is...

Yeah, I'm with Eddie. I've done this in the past. It's just about capturing the correct events and then Distributed Replay just works. I freely admit I haven't used this...

It is worth noting, storing numbers in a varchar field, if they really are numbers and not strings, can lead to other issues down the road. CAST & CONVERT functions...

I'd love to answer this for you, but I don't know the answer. Plus, I work for Redgate, so you know what I'm going to suggest.

XML indexes are not the same as a standard B+Tree clustered or nonclustered index. It doesn't use a histogram and density graph to define the index. Instead, it's a BLOB...

If I recall correctly, this usually happened when the procedure itself created changes within objects in the database. There was also an old bug in 2005. I think we'd need...

Piling on a little. Yes, if the first three columns make the data unique, then you can duplicate the data in DEF as long as ABC is different each time....