Posted by Ben on 11/01/07 12:45

What do you mean?

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99DAF20685204Yazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> The main problem in this issue was the packet size. The packet size
>> setting of SQL Server 2005 required it to be increased. So, after the
>> update statistics and reindexing, the packet size just had to be
>> increased and that solved the slowness problem.
>
> Interesting. I have not heard of anything related to packet size before.
> Thanks for the update!
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Help with SQL query?
• Prev in forum: Re: SQL query question.
• Thread view: Re: Slow Execution Performance

[Reply to this message]