Something like this is probably what you're looking for. My bet would be that with 600,000 rows a temp table will end up being more efficient than a table...

I'm pretty sure that SQL 2000 doesn't have that same capability. I...

Interesting point about how the query optimizer works but I'm more with Garima. ...

William Vach (10/15/2010)

---

...you must connect through the registered servers tree. If you connect through the File|Connect Objects explorer method, the color of the status bar will be the default....

One of the things we offer with our product, an Electronic Health Record, is a service that will create PDFs of the most relevant data. It has all the...

Generic optimizations are difficult to give since how long something takes will vary depending on the schema. One thing that may come in handy is using CTE to handle...

The product I work on is an enterprise application and our clients pay us for a support contract. That contract doesn't cover customizations but that doesn't necessarily mean that...

I wouldn't be surprised if this came up as the user saying, "Hey, on this transitional screen would it be possible to display summary data," it got implemented, and then...

Right. ...

For the enterprise level application I support we "require" all clients to have a DBA that manages their servers. There are a lot of the smaller shops that don't...

Indexes should be looked at in a whole application perspective to get the best setup. Trying to optimize for this specific query could lead to a less than optimal...

If you're looking to track how long each query is taking you can have profiler log to a table or a file and then do averages on the duration. ...

I can't really explain why this would happen but I do have a recommendation. We've solved similar problems in the past by loading information from some of the tables...

Thanks for the links. I haven't had a chance to finish them but I do see your concerns and can start to piece together how that might have caused...

Duplicate rows if something else is working in the table? Yep but there's no way that's the case where we saw the duplicate entries. It was a development...