How do you know it is very slow? What have you measured?

What is the network type you are replicating over? Is it a LAN or WAN?

I recommend you...

It depends what you mean by schema. If you mean a schema object within the database like dbo, there is no direct way to see who and when. ...

1. Use backup compression

2. Stripe your backup across multiple files

3. Change the BUFFERCOUNT

4. Change the MAXTRANSFERSIZE

As always test first.

You might want to be looking into SAN Snapshot backups for something...

It means you probably have an issue somewhere in your storage subsystem. Either disk issues or you somehow saturated it, which is a problem as well.

You can learn more...

This means you are...

Yes, since the corruption is in an non-clustered index you can either REBUILD the index or explicitly drop and recreate it. You also need to make sure you check...

At the least we'd need to see the query to determine why there is a sort at all. Without that I have not clue why there is a sort,...

Looks like this works, but be sure to test especially for performance. Please not how I provided the test data in an easily consumable format so others can just...

Is the RIN required to be sequential (No Gaps)? If not, this will work and eliminates the need for the temp table to generate the identity value. I'm assuming...

I was about to reply when I saw that you found the blog that explains some of the limitations of the DMV's.

I will say that since you are on 2012...

Mile Higher Than Sea Level (11/3/2014)

---

All of this really helped. Thanks!

Thanks so much. I am overwhelmed trying to look at the very useful code including the COALESCE(NullIF(...

The example of the...

Chris Harshman (10/31/2014)

---

I think your ANDs and ORs may be getting mixed up somewhere, the logic in each WHEN looks confusing, maybe parenthesis could help? Also, you say there...

Jonathan Kehayias has a query in this post, http://www.sqlskills.com/blogs/jonathan/tuning-cost-threshold-for-parallelism-from-the-plan-cache/, that shows parallel queries in the cache. I think you can run it against production, but I'm cautious and would...

I don't think I'd do it in a function because I think it'll be slower, here's an example where I think I have the logic you want correct and I...

Since you can see the plan you should be able to see 3 & 4 from my first post which can get you started on tuning.

You can force the query...