Viewing 15 posts - 1,966 through 1,980 (of 3,233 total)
Post the plans and we can take a peek at them. Also, run each query in query analyzer using SET STATISTICS IO ON. Make sure to clean out...
December 4, 2007 at 11:00 am
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...
December 4, 2007 at 10:56 am
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...
December 4, 2007 at 10:54 am
Can you explain why the second value should not be changed? Also, why are you replacing the first 2 characters from the first value?
December 4, 2007 at 10:36 am
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...
December 4, 2007 at 8:42 am
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...
December 3, 2007 at 4:06 pm
U (12/3/2007)
December 3, 2007 at 3:54 pm
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?" ...
December 3, 2007 at 11:13 am
GilaMonster (12/3/2007)
John Rowan (11/27/2007)
I agree in that I've read sooo many posts that were so badly presented that I simply move on to another.
Likewise. I only have so...
December 3, 2007 at 10:57 am
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...
November 29, 2007 at 9:15 am
Yep, and I'm still waiting on that code to test......
November 28, 2007 at 3:19 pm
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...
November 28, 2007 at 8:12 am
Are you having performance problems on your production DB? What has prompted you to begin looking at performance metrics on these 2 servers?
November 27, 2007 at 4:20 pm
See 'Create Table' in BOL. Specifically, look under section F: Complete table definitions.
November 27, 2007 at 4:00 pm
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...
November 27, 2007 at 3:38 pm
Viewing 15 posts - 1,966 through 1,980 (of 3,233 total)