I have been monitoring TCP/IP communication between client and server. In case of time out errors, particular TDS packet is not reaching the client (text representation):

<x!E@}M

dd

"

Y95P3mkFTDWmaster`E#Changed database context to...

Jeff,

 I have installed Ethereal. Would you guggest filtering based on IP address on SQL Server and then capturing all TCP/IP call to from server in question?

Thanks,

Igor

I checked Application log on both client and server. There is no indication of connectivity problem.

Thanks,

Igor

Joe,

I was using Microsoft atricle as a guideline: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

    In my case, index spans multiple files and according to Microsoft '‘Although...

Thank you, peterhe!

Igor

Joe,

   My process is consists of two parts: first step is to collect DBCC SHOWCONTIG output into table for further analysis. It is done for entire database(s). Second step is to...

Joe, Pankaj, Jeff,

I am defragging one index at a time. In fact this is an automated process that analyzes fragmentation levels and decided whether DBCC INDEXDEFRAX or DBCC DBRECINDEX has...

Jeff, Sergiy,

   Thanks for your feedback. Computed column dwRights_Public&4 has, indeed, two  distinct values (0 and 4), even though field type is defined as  INT. As I mentioned before, most...

Still, given that database in SIMPLE recovery mode and DBCC INDEXDEFRAG is executed as series of short transactions, my expectations would be that log file doesn't grow (at at least...

Create and index on computed column (dwRights&4).

I realize that (R.dwRights_Public&4) makes agrument NON-SARGABLE. I found another solution that might work well for my sccenario: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5970

Thanks,

Igor

According to BOL: '

Connection timeout

I do not think this...

   There was something wrong with our network, I believe. When running trace, I noticed that overall connection to network where SQL Server located was slow. For example, even RPD...

Chris,

Unfortunately, I am leaving company tomorrow I will pass on recommendations to developer but won't be able to report results back.

Thanks a lot...

Chris,

I have done some research on UPDATE STATISTICS. It appears that even if threshold of modifications is reached, SQL Server issue statistic update only when first query/stored procedure using referencing...