Re: Do SQLOLEDB Provider supports ADO SEEK ?

From: Stephen Howe (sjhoweATdialDOTpipexDOTcom)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 23:29:38 -0000

> I have used this code to sort out if ADO Seek Method works with Sql Server
> 2000 or not, but it seems to be not, any idea please ?

It might be better if you stated what larger problem you are trying to solve
using Sql Server
Then we can suggest a range of alternative solutions (some of which might be
better) than Seek.

Stephen Howe

Relevant Pages

  • Re: Performance issue with row size and order by
    ... You are probably observing in-memory sort versus on-disk sort. ... The amount of memory sort uses is dynamically tuned. ... SQL Server Storage Engine Development ...
    (microsoft.public.sqlserver.server)
  • Re: How top actually works
    ... So the next one shows that order by clause has affected the result set ... sort these N rows according to my order by clause. ... Ie. you are telling SQL Server ... This is much the same as with rownum in Oracle, ...
    (comp.databases.ms-sqlserver)
  • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
    ... That query looks very much like the SELECT in the procedure you ... The ORDER BY CASE @sort is supposed to only tell SQL to return data ... far as I can call you have <bigquery> thrice in your procedure: ... I was SQL Server 2000 when I wrote this SPROC but we have since ...
    (comp.databases.ms-sqlserver)
  • Re: index versus order by question
    ... How does sql server then sort the table? ... The table in quesion is still sorted accoring to the clustered index. ... I suggest you check out the "Physical Database Architecture" section in Books Online. ...
    (microsoft.public.sqlserver.setup)
  • Re: Regarding Opening a 1GB File for Processing.
    ... > What about using DTS or BULK INSERT to insert this data into SQL Server, ... > your sorting there, and then BCP out the data? ... > file based in the first field, ... > first two fields and sort the list, ...
    (microsoft.public.dotnet.framework.performance)