<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ian Stirk
»
Identifying Queries Running Slower Than...
58 posts, Page 1 of 6
1
2
3
4
5
»
»»
Identifying Queries Running Slower Than Normal
Rate Topic
Display Mode
Topic Options
Author
Message
ianstirk
ianstirk
Posted Wednesday, August 06, 2008 9:22 PM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 47,
Visits: 762
Comments posted to this topic are about the item
Identifying Queries Running Slower Than Normal
Post #547985
Anipaul
Anipaul
Posted Thursday, August 07, 2008 12:28 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787,
Visits: 1,336
Something wrong, not able to read the article...
Post #548020
chris fewtrell
chris fewtrell
Posted Thursday, August 07, 2008 12:40 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 07, 2008 1:00 AM
Points: 1,
Visits: 5
Yes
But the word doc file is legible (although the file name is missing the .doc extension!)
Post #548024
ianstirk
ianstirk
Posted Thursday, August 07, 2008 1:31 AM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 47,
Visits: 762
Hi,
There is a formatting problem with the SQL displayed on the main page.
Please see the associated resources document ‘Identifying queries running slower than normal-SSC.doc’, this has the correctly formatted SQL at the end of the article.
Hopefully the website editor will correct the main display soon.
Thanks
Ian
Post #548043
khushbu
khushbu
Posted Thursday, August 07, 2008 2:39 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, January 21, 2013 11:50 PM
Points: 267,
Visits: 695
Hi
I got error while exec the query
Im on SQL 2005 Sp2
Msg 170, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 43
Line 43: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 97
Incorrect syntax near the keyword 'END'.
Post #548083
eloi.guterres
eloi.guterres
Posted Thursday, August 07, 2008 2:44 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 26, 2011 2:28 AM
Points: 1,
Visits: 11
HI there,
I have the same error mentioned above.
Regards
Post #548085
Maciej-450894
Maciej-450894
Posted Thursday, August 07, 2008 3:07 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 07, 2008 8:47 AM
Points: 1,
Visits: 4
I have the same message on SQl Server 2000
Msg 170, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 43
Line 43: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 97
Incorrect syntax near the keyword 'END'.
Post #548093
ianstirk
ianstirk
Posted Thursday, August 07, 2008 3:11 AM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 47,
Visits: 762
Hi,
Copy the SQL given at the end of the Word document 'Identifying queries running slower than normal-SSC.doc'. It might be worthwhile copying the SQL into Notepad first to remove any ‘bad’ characters.
Hope this helps
Ian
Post #548097
ianstirk
ianstirk
Posted Thursday, August 07, 2008 3:13 AM
SSC Rookie
Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 47,
Visits: 762
Hi,
This routine will NOT work on SQL Server 2000, it uses DMVs.
Thanks
Ian
Post #548099
Nicola Harding
Nicola Harding
Posted Thursday, August 07, 2008 3:16 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 07, 2008 5:25 AM
Points: 2,
Visits: 3
I get error when running query:
"Divide by zero error encountered.
The statement has been terminated."
Any ideas?
Post #548101
« Prev Topic
|
Next Topic »
58 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
