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

Daniel Bowlin (10/19/2010)

---

I've known some people that have tried to make this don't...

Bill_CCAC (10/19/2010)

---

you folks are all fabulous. thank you all.

I had been trying to use the case statement but ran into problems and didn't get the results I was after....

As it's been pointed out you can do a single query and add an age group. From there pivot the data in the reporting application.

That'll take out 99% of...