25 seconds for query on empty table (SS 2005)

And this is on a dual Xeon with 4 Gig of memory.
Here is the script that's taking so long.
Would someone be so nice and try it on their SQL Server 2005 and tell me if
they have the same issue? Thx.
create table #t (tid int, t2 int)
select tid, count(*)
from #t
group by tid with rollup
drop table #tSpeed of light on both my instances (2005 and 2000 with sp3).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pat" <pat@.online.nospam> wrote in message
news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
> And this is on a dual Xeon with 4 Gig of memory.
> Here is the script that's taking so long.
> Would someone be so nice and try it on their SQL Server 2005 and tell me if
> they have the same issue? Thx.
> create table #t (tid int, t2 int)
> select tid, count(*)
> from #t
> group by tid with rollup
> drop table #t|||Thanks for that.
"Tibor Karaszi" wrote:
> Speed of light on both my instances (2005 and 2000 with sp3).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pat" <pat@.online.nospam> wrote in message
> news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
> > And this is on a dual Xeon with 4 Gig of memory.
> > Here is the script that's taking so long.
> > Would someone be so nice and try it on their SQL Server 2005 and tell me if
> > they have the same issue? Thx.
> >
> > create table #t (tid int, t2 int)
> >
> > select tid, count(*)
> > from #t
> > group by tid with rollup
> >
> > drop table #t
>

25 seconds for query on empty table (SS 2005)

And this is on a dual Xeon with 4 Gig of memory.
Here is the script that's taking so long.
Would someone be so nice and try it on their SQL Server 2005 and tell me if
they have the same issue? Thx.
create table #t (tid int, t2 int)
select tid, count(*)
from #t
group by tid with rollup
drop table #t
Speed of light on both my instances (2005 and 2000 with sp3).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pat" <pat@.online.nospam> wrote in message
news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
> And this is on a dual Xeon with 4 Gig of memory.
> Here is the script that's taking so long.
> Would someone be so nice and try it on their SQL Server 2005 and tell me if
> they have the same issue? Thx.
> create table #t (tid int, t2 int)
> select tid, count(*)
> from #t
> group by tid with rollup
> drop table #t
|||Thanks for that.
"Tibor Karaszi" wrote:

> Speed of light on both my instances (2005 and 2000 with sp3).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pat" <pat@.online.nospam> wrote in message
> news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
>

25 seconds for query on empty table (SS 2005)

And this is on a dual Xeon with 4 Gig of memory.
Here is the script that's taking so long.
Would someone be so nice and try it on their SQL Server 2005 and tell me if
they have the same issue? Thx.
create table #t (tid int, t2 int)
select tid, count(*)
from #t
group by tid with rollup
drop table #tSpeed of light on both my instances (2005 and 2000 with sp3).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pat" <pat@.online.nospam> wrote in message
news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
> And this is on a dual Xeon with 4 Gig of memory.
> Here is the script that's taking so long.
> Would someone be so nice and try it on their SQL Server 2005 and tell me i
f
> they have the same issue? Thx.
> create table #t (tid int, t2 int)
> select tid, count(*)
> from #t
> group by tid with rollup
> drop table #t|||Thanks for that.
"Tibor Karaszi" wrote:

> Speed of light on both my instances (2005 and 2000 with sp3).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Pat" <pat@.online.nospam> wrote in message
> news:ACCC8738-BAAC-4D17-9E6D-98DC9444741B@.microsoft.com...
>

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?
Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/arc...1/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:

>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:
>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/ar...11/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:

>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>