I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
query
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
but
imported to MS Access?
Can you answer this question?
Thank you in advance for posts
Marcin from Poland.
Re: CONTAINS performance ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization,...SQL Server tables. ... (microsoft.public.sqlserver.fulltext)
Re: Indexing Service, Openquery and sp_executesql ...SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing... (microsoft.public.sqlserver.fulltext)
Re: Problem using Access or Query Designer to run queries in SQL Serve ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ...>[ODBC SQL Server Driver] Timeout Expired ... (microsoft.public.sqlserver.odbc)
Re: Transaction Isolation Level ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ... (comp.databases.ms-sqlserver)
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... This process runs very quickly if run through Query... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.dotnet.framework.adonet)
