All you can do is call them on it. If you're not satisfied with their answer, then evaluate your options.

Based on the query above, I'm seeing slightly different results. I'm getting an index seek on the userlogin when I've got it indexed and a scan on the tableofdates (shock,...

And COUNT and possibly GROUP BY

The company I'm at currently has an annual review process. You may or may not get a raise, but you'll at least know what the boss thinks of you and...

Did you try putting an index on the time table? I think it'll make a bit of a difference. Same with your user login table.

May as well pile on...

Good Job Brandie. I couldn't agree more.

Enjoying the work allows you to bring passion to the job. That passion will translate to accomplishments within...

Use the OUTPUT clause from the DELETE statement to insert the data as it gets removed.

From what you described, I'd move on to coding now. As you code, when you get portions of the app working, run Profiler while you test the app so that...

I tried it. It worked.

I took your table & loaded it with data (still beta testing Red Gates SQL Data Generator). I then created this table:

CREATE TABLE tableofdates

...

I'm strapped for time, so I might not be able to experiment with this, but what if you created the equivalent of a table of numbers, but instead made a...

I agree. If you're processing 15 rows of data and it doesn't matter that it takes 10 seconds, walk away a winner.

If you're trying to build a large scale, repeatable,...

At my company, we do clean up & hide the data from production, but not nearly enough and, unfortunately, not across all teams. The biggest problem we have is getting...

Michael Valentine Jones (3/6/2008)

---

We are also looking for a financial auditing expert who can troubleshoot our financial records without making people uncomfortable about violating financial accounting standards and inconvenient laws...

Jeff Moden (3/6/2008)

---

Ummm... I gotta say, "Not always". I've...

Rishi Girdhar (3/6/2008)

---

Many times we need to use function 'MAX' in 'Select' clause specially for dates. Does anyone has a thought on different approach.

For example

select max(a.closedate) as closedate, a.offerid...