467,907 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

Group By Query Casues TimeOut Error

I have a table with 6 million rows.
I'm trying to perform a group by query that incudes a row count of the
PK column:

SELECT COUNT(DataID) AS Cnt, Column1Name
FROM dbo.TableName
WHERE (Column2Name = N'p')
GROUP BY Column1Name

I have the query timeout set to 0 in Enterprise Manger. However, if I
run this query, either in Enterprise Manager or in Query Analyzer, I
get the following error message:

[Microsoft][ODBC SQL Server Driver]Timeout expired

A little baffled as to why and how to run this query.

Any help is appreciated.
lq

Oct 22 '06 #1
  • viewed: 2788
Share:
2 Replies
Apologies for the multiple posts in this group. My connection kept
getting dropped and I didn't know the post had succeeded. lq

On Oct 22, 12:21 pm, "laurenquantrell" <laurenquantr...@hotmail.com>
wrote:
I have a table with 6 million rows.
I'm trying to perform a group by query that incudes a row count of the
PK column:

SELECT COUNT(DataID) AS Cnt, Column1Name
FROM dbo.TableName
WHERE (Column2Name = N'p')
GROUP BY Column1Name

I have the query timeout set to 0 in Enterprise Manger. However, if I
run this query, either in Enterprise Manager or in Query Analyzer, I
get the following error message:

[Microsoft][ODBC SQL Server Driver]Timeout expired

A little baffled as to why and how to run this query.

Any help is appreciated.
lq
Oct 22 '06 #2
Hi,

Are you running the query from the same box? If not, what kind of
connectivity do you have to the box?

Also, what kind of indexes are in place for the query?

SQL Version and Service pack info would also be good.

laurenquantrell wrote:
Apologies for the multiple posts in this group. My connection kept
getting dropped and I didn't know the post had succeeded. lq

On Oct 22, 12:21 pm, "laurenquantrell" <laurenquantr...@hotmail.com>
wrote:
I have a table with 6 million rows.
I'm trying to perform a group by query that incudes a row count of the
PK column:

SELECT COUNT(DataID) AS Cnt, Column1Name
FROM dbo.TableName
WHERE (Column2Name = N'p')
GROUP BY Column1Name

I have the query timeout set to 0 in Enterprise Manger. However, if I
run this query, either in Enterprise Manager or in Query Analyzer, I
get the following error message:

[Microsoft][ODBC SQL Server Driver]Timeout expired

A little baffled as to why and how to run this query.

Any help is appreciated.
lq
Oct 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Dunc | last post: by
6 posts views Thread by Martin Eyles | last post: by
4 posts views Thread by mikado | last post: by
reply views Thread by laurenquantrell | last post: by
reply views Thread by laurenquantrell | last post: by
1 post views Thread by =?Utf-8?B?QW5kcmV3?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.