AJHall (10/22/2010)

---

This disconnect has become niche as I’m aging. I often find myself explaining, especially in this economy, that firing a high salary IT worker might be more crippling to...

What about this forum?

http://www.sqlservercentral.com/Forums/Forum1550-1.aspx

We need way more info than that to optimize this query.

We need table definitions (create table scripts) along with all the keys, indexes and triggers if any.

We also need sample...

No sweat, I'm glad I learned this...

Confirmed, doesn't work on sql 2005 standard SP 2

It's like air guitar... it's pretend code rather than actual table scripts and actual data which gives you the final and tested query.

Compare both execution plans to find the difference.

It's likely a parameter sniffing issue (plenty of articles in google about that)

Why would you leave so much ram for windows?? 38.4 Gb seems like a lot for nothing... especially if nothing else is running besides sql server db engine.

I don't know if it makes sens for your data, but I usually copy the begin and end date filters in the derived tables as well when I can.

This usually...

There's no way this is the whole query. I have a small laptop here and returning 1M records takes only seconds.

That means that your query is either way more...

Geoff A (10/20/2010)

---

add an index. (if its not there)

USE [YourDataBaseName]

GO

CREATE NONCLUSTERED INDEX [IX_Deleted_Ind ] ON [dbo].[Table1]

(

[Deleted_Ind] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY...

How long did it take before you started using our recommendations?

How much seconds did you save from the original query compared to the new one.

It's 9 seconds less?

9 secs total.

It started from 10 secs or 10 days?

Richard M. (10/19/2010)

---

TemDB will not automatically shrink back, but you need to take something bigger in consideration: how often will this happen? If it will be frequent, it would be...