Advertisement

01.23.2006 at 03:34AM PST, ID: 21706367
[x]
Attachment Details

Query returning incorrect number of rows

Asked by ShogunWade in MS SQL Server

Tags: , , ,

Hi All,

Ive got a pretty wierd problem.

A simple table with a stored procedure which essentially does:

SELECT * FROM MyTable WHERE MyIntCol=@MyParamValue

This is on SQL 7 SP2

sporadically (approx 1 in 3000 times)   the call returns too few rows.     ive traced it with profiler, loged rowcounts etc etc.    dbcc checkdb and dbcc checktable say there is no issues.

Whats interesting is that it always returns 8 rows when it goes wrong.    For all legal values of the parameter the expected rowcount is between 50 and 1000 rows.     The table its querying is a static table (updated only once a month in a batch process).

My suspicion is this this is a bug in SQL 7 SP2 since i can find no other tangiable explination.    

Any ideas ?  or references to such a bug documented ?


Cheers



Start Free Trial
 
Keywords: Query returning incorrect number of rows
Title
1 dbcc checkdb and locking issue
2 DBCC CHECKDB
3 Rowcount
4 Errors while running DBCC CHECKDB
5 DBCC CheckDB
6 DBCC CHECKDB failing (Integrity Chec…
 
Loading Advertisement...
 
[+][-]01.23.2006 at 03:38AM PST, ID: 15765114

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:06AM PST, ID: 15765304

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:12AM PST, ID: 15765333

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:23AM PST, ID: 15765377

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:27AM PST, ID: 15765399

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:31AM PST, ID: 15765413

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:31AM PST, ID: 15765418

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 04:33AM PST, ID: 15765427

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.23.2006 at 11:07AM PST, ID: 15769345

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.05.2006 at 09:28AM PST, ID: 16108290

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.05.2006 at 09:59AM PST, ID: 16108433

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]03.05.2006 at 12:57PM PST, ID: 16109251

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.10.2006 at 12:17PM PST, ID: 16158159

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: returns, few, query, number
Sign Up Now!
Solution Provided By: modulo
Participating Experts: 3
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32