I see what everyone is saying and I don't disagree with them, but I know where Brandie is coming from. You make compromises in order to make things work well....

They...

I'm really not going to do the work for you.

I'll give you a hint to get you started though. There are three items listed above that are people. Figure out...

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural...

For the same server, with the same data, on the same database, with identical statistics, for a single execution, with absolutely zero contention, you should be seeing roughly the same...

Thanks for posting your solution. Now when anyone searches for this same problem and finds it, they'll know what you did to solve it. That really helps.

I won't design it for you. I don't get any grade.

Don't think of it as wills and people. Just think of it as things. Some of the requirements you have...

You can't do an include on a constraint. Your only real alternative would be to recreate the index as just a unique, non-clustered index. Then you could do includes. You...

You might also want to take a look at Michelle Ufford's scripts[/url].

If it's just doing scans (no WHERE clause), you're completely subject to any number of areas of contention, on the disk, in memory, on the CPU. You could be seeing...

First off, are you taking regular log backups? If you're not taking those, then you can't do a restore to a point in time anyway. Determine if you need to...

All I can do is guess based on what you've provided.

How about using SQL Agent. When you set up the Job in SQL Agent you'll have to create Steps. The...

+INFINITY!

But, doing what Jack is suggesting will mean that you still have data in the table that doesn't match the related table. I'd suggest tracking that data down and fixing...

You have to look at the execution plan to understand how the query is being resolved. It may not be using your index at all, or it might just be...