Thanks a lot GilaMonster. I'll be checking on this

Thanks Grant Fritchey!

Michael, Derrick: that's exactly what I was looking for. THANKS A LOT!

thanks Steve Jones. I'll take a look

bitbucket-25253, thanks for your answer.

My procedure is the standard one for Sql server 2005, it's not a custom procedure. I created a maintenance task "Rebuild Index"

GregoryF,Elliott W. Thanks a lot!

I was looking for a general advice about how to troubleshoot memory problems on SQL SERVER 2005. At this point I'm not sure about the differences...

Thanks dmoldovan! I'll take a look to that

Dave Ballantyne (10/16/2009)

Which will never the actively used by this query as this

ZipCode like '%' + @ZipCode

Gets all the zip codes ending...

Thanks for all your replies guys! You're simply GREAT

I'll analyze everything you said. I did other simper queries before this I pasted and I also had big differences of performance...

No idea? It must be something related to sp_executesql. Thanks!

3 questions related to this problem

- How do I check the current value for XACT_ABORT?

- Once I ser XACT_ABORT to ON remains like that until you explicity set to OFF...

I'll take a look. Thanks much!!!

Anyhow, it's very weird. All servers are configured equally and now seems to be no difference.

The first step I had to set up the...

for quering the data. Ther is any other way?

Sorry, my fault.

I was trying to insert results to a table like this

SELECT * INTO #temp

FROM ::fn_trace_gettable(N'D:\TestTrace3', DEFAULT)

But an extension is added (.trc) so I have to do it...

The status is 1 but I see no file on thi path 'D:\TestTrace3.trc'

Is this OK?

Thanks!