Viewing 15 posts - 6,901 through 6,915 (of 7,631 total)
Do you mean which queries have had the longest average run time since the server was started? Or do you mean which currently running queries are the oldest?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 17, 2008 at 6:41 pm
BEGIN TRY
drop table ##tmp_mj_jobSync
END TRY BEGIN CATCH END CATCH
Select * into ##tmp_mj_jobSync from mj_jobSync
This works also... 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 17, 2008 at 5:56 pm
If you use PerfMon (and I do recommend it), then be sure to include these in addition to those already mentioned:
PhysicalDisk: %Idle and Disk Transfers/sec for each volume visible
Memory: Page...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 9:53 pm
Suggestion: Put a service wrapper around your license key validation DLL and call it with LPC.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 9:02 pm
Yeah, without the BEGIN..END it's an infinite loop!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 8:52 pm
In my experience, Dynamic queries are less likely than compiled ones (i.e., sProcs) to do that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 6:51 pm
:crazy: Blimey! Whats with all of the smiley faces? :unsure: We've got more yellow dots here than a teenage fanboy with a chocolate addiction! :w00t:
😉
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 6:36 pm
Matt Miller (5/16/2008)
rbarryyoung (5/16/2008)
...(even Matt got here before me!)...
Hey now! where the heck did THAT come from??? :hehe::w00t:
Sheesh - travel home to see the wife, and get smacked around on...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 4:46 pm
Here's the questions that I generally ask:
- Why do you thin that it is an Index problem?
- Is everything slow, or are specific things slow?
-- if specific: what are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 4:24 pm
Actually, this all seems pretty consistent with the documented behavior for READPAST. From BOL:
READPAST
Specifies that the Database Engine not read rows that are locked by other transactions. Under...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 3:56 pm
ALZDBA (5/15/2008)
btw:
did you disable the InternetExplorer settings / advanced / Security "Check...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 3:40 pm
Well, looks like I will be going. Hope to see some of you there!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 3:36 pm
Oops, apparently, I was a little late to this party (even Matt got here before me!), but I believe that it is now apparent what I was saying above: this...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 3:21 pm
SQLServerLifer (5/15/2008)
The GETDATE() function returns a DATETIME type. Therefore it will inherit the same rounding limitation.
Yes, but it might add "Limitations" of its own. In particular (and what this...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 3:07 pm
In most respects, a stored procedure is no different from a user/client executing all of the same statements in one batch.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 15, 2008 at 9:03 pm
Viewing 15 posts - 6,901 through 6,915 (of 7,631 total)