Re: Query Analyzer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Mon, 22 Jan 2007 14:27:53 -0800

Simon (Simon@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:

We are connecting via our internet link which I am aware isn`t the
fastest. However the data set is only 200 rows and about 10 columns. A
query that takes 2 seconds on the server can take pushing 10 mins. Which
is a massive performance hit.

Is that a single query? In such case, does it happen to includ a call to
user-defined function?

In any case, try SET NOCOUNT ON. If there are intermediate results, all
those (1 rows affected) can slow down things quite a bit.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Re: Query Analyzer
  - From: Robert Klemme

Prev by Date: Re: Help with SQL 2005 and Sourcesafe 6
Next by Date: RE: Diagram changes
Previous by thread: Re: Query Analyzer
Next by thread: 2005 Transfer Objects Task fails with "The PRIMARY filegroup must have at least one file."
Index(es):
- Date
- Thread

Relevant Pages

Re: Discussing 3 different strategies for deleting from multiple tables
... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
(microsoft.public.data.ado)
Re: Efficient coordinated queries??
... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
(microsoft.public.dotnet.framework.adonet)
Re: Calculated field in pass through query
... Using the same hardware, with a single user, Jet will be faster than MS SQL ... Server simply because Jet does not use log. ... Even within MS SQL Server, ... same query on the same data but on another MSSQL db, ...
(microsoft.public.access.queries)
Re: MailMerge hangs and crashes with Access on Server
... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
(microsoft.public.word.mailmerge.fields)
Re: Website Connectivity?
... does the website just query our server? ... How do I give it a login to query the SQL Server running on the server? ... It would be a serious security breach to allow a remote website to ...
(microsoft.public.windows.server.sbs)