FIX: SELECT Query Involving Bit Datatype Slower on SQL 7.0 than SQL 6.5

Article translations Article translations
Article ID: 244549 - View products that this article applies to.
This article was previously published under Q244549
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56069 (SQLBUG_70)
Expand all | Collapse all

Symptoms

A SELECT query containing a WHERE clause, which references a bit datatype, may run slower on SQL 7.0 than SQL 6.5.

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8b39115b-879d-45fe-80d1-4f0900993a92&displaylang=en
For more information, contact your primary support provider.

Properties

Article ID: 244549 - Last Review: October 26, 2013 - Revision: 3.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB244549

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com