Group By Query Casues TimeOut Error

[laurenquantrell]

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

[laurenquantrell]

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" <[e-mail]>
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

[Kart]

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" <[e-mail]>
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