sys.dm_exec_query_stats and sys.dm_exec_procedure_stats are aggregates showing all the times that the query has been called. No way to link it to an individual call, as Gail says.

Yes. You're right. The cluster key is stored as part of non-clustered indexes anyway.

islandwino (9/28/2011)

---

Grant Fritchey (9/28/2011)

---

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...

setvij (9/28/2011)

---

I have a similar scenario - I am have multiple clients that need access to a common database and they have their own separate tables - so I plan...

Well done Gail. I have...

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...