CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Slow Query analyzer
|
Zen S.
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 Slow Query analyzer
Hi,
I'm having trouble with a performance of query analyzer.
It takes 20 to 40 seconds to execute a simple query.
Any sugestion how to solve this will be greatly
apprecieated. I,m learning SQL.
Thanks much.
Report this post to a moderator
|
|
 06-29-02 03:25 AM
|
|
Tom Moreau
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: Slow Query analyzer
I've not heard of QA being slow. Rather, it is likely that the query is
slow. Do you get the same performance when the query is run through osql?
Perhaps you can show us your DDL - including indexes and keys - and the
query.
--
Tom
----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Zen S. wrote in message < 139b501c21f1d$149ea890$3aef2ec
f@TKMSFTNGXA09>...
Hi,
I'm having trouble with a performance of query analyzer.
It takes 20 to 40 seconds to execute a simple query.
Any sugestion how to solve this will be greatly
apprecieated. I,m learning SQL.
Thanks much.
Report this post to a moderator
|
|
|
06-29-02 12:25 PM
|
|
Zen S.
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: Slow Query analyzer
Hello Tom,
I've just installed Enterprise edition and tryed to play
with Northwind database, that's all. If you have any
sugestions, let me know. Thank you.
>-----Original Message-----
>I've not heard of QA being slow. Rather, it is likely
that the query is
>slow. Do you get the same performance when the query is
run through osql?
>Perhaps you can show us your DDL - including indexes and
keys - and the
>query.
>
>--
> Tom
>
>----------------------------------------------------------
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
>SQL Server MVP
>Columnist, SQL Server Professional
>
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>www.apress.com
>---
>Zen S. wrote in message <139b501c21f1d$149ea890
$3aef2ecf@TKMSFTNGXA09>...
>Hi,
>I'm having trouble with a performance of query analyzer.
>It takes 20 to 40 seconds to execute a simple query.
>Any sugestion how to solve this will be greatly
>apprecieated. I,m learning SQL.
>Thanks much.
>
>
>.
>
Report this post to a moderator
|
|
|
06-30-02 05:25 AM
|
|
2lazybutsmart
The Game Never Ends
Registered: Jun 2002
Location: Toronto
Country: Canada
State:
Certifications: MCSD, MCP
Working on: MCSD.net, MCDBA, MCT
Total Posts: 684
|
|
|
|
06-30-02 12:18 PM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
