freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Locking & SQL Server 7.0

From: Bob Kline <bkline AT rksystems.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: Locking & SQL Server 7.0
Date: Wed, 24 Oct 2001 11:42:44 -0400 (EDT)

On Wed, 24 Oct 2001, Brian Bruns wrote:

> If it is the update statement from below that is causing the
> problem, you may need to check your index on LABEL_ID and make sure
> distribution statistics are up to date (anyone know if SQL Server
> still uses update stats?).

It's done automatically now, though you can still do it manually (and
it's possible to encounter some rare cases where that would be
appropriate). Probably not an issue here.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com

Locking & SQL Server 7.0, Steven Campbell, 10/24/2001
- <Possible follow-up(s)>
- Re: Locking & SQL Server 7.0, Brian Bruns, 10/24/2001
- Re: Locking & SQL Server 7.0, Bob Kline, 10/24/2001
- RE: Locking & SQL Server 7.0, Lowden, James K, 10/24/2001
- Re: Locking & SQL Server 7.0, James Cameron, 10/24/2001