469,636 Members | 1,921 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Ridiculously Slow SqlServer2005 Sorting?

Why does the following simple query against an SqlServer2005 table in an ASPNET2 website returning less than 10 rows:

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1

take no time at all (less than 1 second)

yet the following sorted query against the same table (same number of returned rows):

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1 ORDER BY seq_num

takes almost 20 seconds?

- Mark
Dec 23 '05 #1
2 1173
Is the response time identical from Query Analyzer or the new IDE (SQL
Workbench - is it still called that?)

"Mark Olbert" <Ch*********@newsgroups.nospam> wrote in message
news:69********************************@4ax.com...
Why does the following simple query against an SqlServer2005 table in an
ASPNET2 website returning less than 10 rows:

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum
<> 1

take no time at all (less than 1 second)

yet the following sorted query against the same table (same number of
returned rows):

SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum
<> 1 ORDER BY seq_num

takes almost 20 seconds?

- Mark

Dec 23 '05 #2
For those who might run into this same slow sorting behavior:

I'm not sure exactly what I did to "cure" it, but fiddling around with the configuration of SqlServer2005 services on my server, and
with the "surface area" management utility, apparently resolved the problem (I didn't do anything to the installation on my client
machine where the problem appeared).

- Mark
Dec 24 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James Aguilar | last post: by
5 posts views Thread by Stefan | last post: by
50 posts views Thread by diffuser78 | last post: by
1 post views Thread by SeeSharp Bint | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.