473,216 Members | 1,315 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 software developers and data experts.

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
2 3222
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Mathieu Blais | last post by:
Hi, I need to capture the Script timeout error if that is possible. I know I can increase the timeout value in the server settings or in the scripts itself but I really want to make sure that no...
3
by: Dunc | last post by:
I've got a c# app that reads a database of 3,000 records. "Interesting" thing is when I access 3 certain records, I get a database timeout error. The code is very simple, and runs fine for the...
6
by: Martin Eyles | last post by:
I am trying to perform a very long query on an MSSQL database, using ASP.NET, and making the code behind in VB.NET. I have been receiving timeout error, so I thought I would add Connect Timeout to...
4
by: mikado | last post by:
Hi, I want to access the gmail account through net/pop library and I try this example : Class: Net::POP3 However,I have a timeout error such that: c:/ruby/lib/ruby/1.8/timeout.rb:54:in...
0
by: 1harsh789 | last post by:
Hi, Can anyone please tell me about What is ODBC Query timeout error? And How to resolve this issue. Thanks.
0
by: laurenquantrell | last post by:
I have a table with 6 million rows. I'm trying to perform a group by query: SELECT COUNT(CityID) AS Cnt, Country FROM dbo.tblCitiesWorld WHERE (FC = N'p')
0
by: laurenquantrell | last post by:
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...
1
by: =?Utf-8?B?QW5kcmV3?= | last post by:
Hello, friends, Our have a .net 2003 website using c#.net. We want to let our users to have longer timeout time, and we did in Web.config: <authentication mode="Forms"> <forms...
1
by: nilaangel78 | last post by:
Hi, I am developing winforms project using vb.net. In this i am connecting SQL 2000 DB using odbc connection. When i run SQL select query i am getting timeout error. But the same select query...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.