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

I'm impressed if you can write the TSQL so that it fully performs and returns all the correct data out of the gate. It usually takes me a pass or...

Speaking only for myself, I won't be applying for that position.

:smooooth:

You can run the query and capture the actual execution plan. There's a button on the default tool bar, look for the tool tip that says "Include Actual Execution Plan"...

Right now I'm trying to uninstall 2008 from a virtual machine.

For a good overview, read the book "Database Administration" by Craig Mullins. Best summary of the job I've ever seen.

Do...

Well, back in the day... 6.5, 7.0, that was true, to a degree. But it hasn't been true at all for years & years now. Here's an introduction to performance...

Yeah, sorry about that.

I sent an email to the group this morning. Did you get it?

Profiler and Perfmon are your bestest friends. There are also a number of dynamic management views available in 2005 that list missing indexes, etc.

A seek is when a particular value (or values) is pulled out of an index. Think of it like looking up a particular index card (OK, people may not know...

That's called RBAR (reebar) processing and means Row-By-Agonizing-Row. It's definately not the way to go in most cases.

Instead, you need to focus on the results that you want as a...