Craig Farrell (1/19/2011)

---

Ferguson,

First, I've found that Monster and Dice tend to be hit or miss in both directions. Not only do a lot of the applicants come across as...

SELECT EmpId, SUM(CASE WHEN ColName IN ('comp1', 'comp2', 'comp3') THEN 1 ELSE 0 END) AS HasAllItems, COUNT(*) AS ItemsCnt FROM #tmp GROUP BY EmpId HAVING SUM(CASE WHEN ColName IN (Select...

Where do you get the 1935 date from the tmp2 table? I don't see that anywhere in the input.

Then it's still the estimated plan.

I've never had the plan NOT appear after the queries were done running.

Where are you looking for it? In the default settings of SSMS,...

I wish I knew... I never found a solution and had to build the 5 projects (not that it's real long, just annoying).

I'd start by reading this if I were in your shoes:

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

A "missing" index is an index that if created, could improve performance.

The article link shows you how to find...

So what's the question?

An index can't be missing.

Are you talking about an index you created and now is deleted?

Are you talking about the warnings in the execution plan that creating extra indexe(s) would improve performance?

SELECT EmpId, SUM(CASE WHEN ColName IN ('comp1', 'comp2', 'comp3') THEN 1 ELSE 0 END) AS HasAllItems, COUNT(*) AS ItemsCnt FROM #tmp GROUP BY EmpId HAVING SUM(CASE WHEN ColName IN ('comp1',...

Technically speaking....

I have a corporation in Canada. Can't you hire my consulting corporation to contract for you in the states? Or are there laws against that?

Again technically speaking....

Wow you're either not able to understand english or you're just trying to piss us off.

READ THE FREAKING ARTICLE that Gail refferred you 3 times to already.

Post the scripts we...

There's nothing normal in SQL server.

It would be abnormal if the avg is 1M reads and then all of a sudden, it jumps 1000 folds to 1 Billion reads.

You certainly...

I see. So we're back to a simple if in ± 20 triggers. Sounds like the easiest doable way at the moment.

It only sounds like you got some tuning to do on that query!!!

With only 1 write per run, I wouldn't worry about it.