|
|
Posted by Kart on 10/23/06 15:24
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
Navigation:
[Reply to this message]
|