Tx, but I never get in through that door! :w00t:

Assuming you can find a mixture of Gail, Jeff, Randal and Ben Gan who can work 100 hours / week.

How much is this position going to cost him?

Craig Farrell (1/19/2011)

---

Hm, interesting find, Ninja.

There are a number of concerns, from my perspective, with that posting. For reference I'll post it here with notes:

Disclaimer: All quoted material...

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