Re: Query performance

Hi Phil,

Thank you for making it clear.

By default, the SQL error log is located at Program Files\Microsoft SQL
Server\MSSQL.n\MSSQL\LOG\ERRORLOG

Also, you may create a SQL Profiler Trace to trace the behavior of the
Transcation.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • WHERE 1=2 with performance nightmares
    ... Recently we started seeing this "WHERE 1=2" in sql profiler trace that even makes a lot of our sql statements invalid when there is *already* a WHERE clause in our sql. ... Has that turned on some kind of server setting that cause all this? ...
    (borland.public.delphi.non-technical)
  • Re: Connection to SS 2000 failing
    ... sort needs to spill to disk c) a hash needs to spill to disk, ... Some other processes is hogging your system, and the posting of the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.connect)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.queries)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.macros)
  • Re: Microfocus & Oracle data types
    ... Thanks, Robert. ... SQL is fairly new to me ... ... > Top posting ... > Hello Michael ...
    (comp.lang.cobol)
Loading