That's not going to get him what he's described and shown in his example. Your code will always remove the first character and it sounds like he needs some...

From my experience the LEFT JOIN typically performs better, but in reality it depends. I will usually start with the LEFT JOIN and only change it if the reads...

Can you explain why the second value should not be changed? Also, why are you replacing the first 2 characters from the first value?

What you are looking for is a tool that will read in all of the SQL queries and then spit out only problem queries. You can configure Profiler to...

Absolutely!! The fact that they refuse to disclose this to you is absurd and counterproductive. Whenever I work with a client that is having performance problems and I find...

U (12/3/2007)

---

I don't mind running Profiler in a Dev environment but when there is a problem in Production environment I would rather prefer a tool that will quickly capture and...

Mike C (12/3/2007)

What's the proper etiquette when the OP posts a question in the 2000 forum, and subsequently asks "is there an easier way to do this in 2005?" ...

GilaMonster (12/3/2007)

---

Likewise. I only have so...

If your code returns a result set in QA, the fact that your ASP app is not getting results has nothing to do with what type of temporary structure you...

Yep, and I'm still waiting on that code to test......

I second Grant here. You should run profiler to identify poorly performing processes. I would also recommend running Windows Performance Monitor along with Profiler. Take a close...

Are you having performance problems on your production DB? What has prompted you to begin looking at performance metrics on these 2 servers?

See 'Create Table' in BOL. Specifically, look under section F: Complete table definitions.

As Lynn stated, not enough information! On top of the table DDL and the code that you've already tried (if any), we need to know if you want to...

Eric,

Timeouts are usually caused by resource contention. The problem that you have with using Virtual servers is that you may be sharing resouces with other Virtual servers running...