The 3rd party tools do stuff that the native doesn't or they do stuff the native does better or faster or easier.

I ask because I'm the product evangelist for Red...

Assuming updates to different partitions, no you shouldn't see blocking while those updates are occurring. You can still block within a partition though.

As to your second question, no, 1/2 a...

Assuming I understand what you're asking, make query A into a sub-select that acts as a table for query B. I can't vouch for performance, but that's how I'd start....

Does that software run a SQL Backup or is it some custom binary? If it's custom, I'd ask for an immediate test of the restore to see that your databases...

Here's the predicate from the properties (don't use the tool tip, not enough info there).

[IARTS].[dbo].[Cust_Ident_Type].[Effective_DT] as [CIT].[Effective_DT]<=[@GetDate] AND ([IARTS].[dbo].[Cust_Ident_Type].[End_DT] as [CIT].[End_DT] IS NULL OR [IARTS].[dbo].[Cust_Ident_Type].[End_DT] as [CIT].[End_DT]>[@GetDate])

The two columns referenced...

That's a big list, I don't think you're going to find a single source for all of it. My book on query tuning has a performance checklist that might help,...

Kwisatz78 (9/28/2011)

---

Ok so my plan would be to trace the workload against that particular table. Then on my test system replay that and view the results, then drop then...

Ninja's_RGR'us (9/28/2011)

---

Grant Fritchey (9/28/2011)

---

Just check the execution plans on the queries to see what, if anything, changes when the index goes away. It's not a measure of performance, but it's...

WayneS (9/28/2011)

---

Grant Fritchey (9/28/2011)

---

Jack Corbett (9/28/2011)

---

Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI...

Further, if I set a GO in place to separate the commands, it works right every time. Trying it on Denali now.

Same behavior in Denali.

Guess based on behavior, the...

Not sure, it seems to lag by an execution. If I run it once, it shows as the way I ran it previously.

Version: Microsoft SQL Server 2008 R2 (RTM)...

I am NOT...

Just check the execution plans on the queries to see what, if anything, changes when the index goes away. It's not a measure of performance, but it's always good to...

Without the structure, this is just a guess, but couldn't you do a subselect to get the unique set of two columns and then join that to the rest of...

I have used a unique value in a compound index before, but not one that was already indexed, let alone the PK on the table and, I assume, the clustered...