Viewing 15 posts - 1,201 through 1,215 (of 7,636 total)
And please use the [ code ] tags.
[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]
December 10, 2009 at 11:46 am
Please add a title to this Thread, otherwise most people will not be able to read it.
[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]
December 10, 2009 at 11:36 am
Are they both running on the same server/instance and the same disks?
[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]
December 10, 2009 at 11:21 am
sqllearner-339367 (12/10/2009)
Lowell,Grant,Barry,As lowell suggested I executed stored procedure as following and attaching new execution plan.
set ansi_nulls on
go
SET QUOTED_IDENTIFIER ON
go
exec getorders 1,10,0,0,''
go
Much better.
[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]
December 10, 2009 at 9:42 am
sqllearner-339367 (12/10/2009)
For clarity I have posted the exact code of stored procedure and adhoc query below
...
From the above code we can come to know that queries are same in...
[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]
December 10, 2009 at 9:41 am
Looks good, Ron. Though I cannot test it right now to be certain, this is basically the approach that I would take.
[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]
December 10, 2009 at 9:34 am
Also, *please* stop going back and editing you previous posts and attachments, it's just making a confusing situation worse.
Instead, when you have new or corrected information or files, then make...
[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]
December 10, 2009 at 9:19 am
sqllearner-339367 (12/10/2009)
I have just named the temp tables differently. I have now include the execution plan for both adhoc and stored procedure, please take a look when you next...
[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]
December 10, 2009 at 9:16 am
And the two sqlplans in the attached ZIP appear to be for yet two more SQL queries, both completely different from each other and from the two queries above.
[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]
December 10, 2009 at 8:57 am
sqllearner-339367 (12/10/2009)
Hi Grant,Please find the xml version of execution plan for stored procedure followed by dynamic query below
Stored Procedure
...
FYI: these are for completely different SQL queries'
The first (stored procedure) is...
[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]
December 10, 2009 at 8:53 am
Roman-334857 (12/10/2009)
After googling found this
State=16 means that the incoming user does not have permissions to log into the target database. So...
[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]
December 10, 2009 at 8:27 am
Leaving my mistaken post out of it then, the outstanding question still is "Why does it choose to truncate to 6 decimal places?"
[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]
December 10, 2009 at 8:12 am
Since the View that you want to ALTER already exists, you cannot create is as a new object, but must instead retrieve it from the database's Views collection:
myview = db.Views("Test4_View",...
[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]
December 10, 2009 at 1:59 am
sknox (12/9/2009)
I beg to differ, RBarry. MAX() returns the maximum of the two values. So MAX(6,49) is 49.
Uuhhhh, ... right you are. Never mind. :blush:
[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]
December 10, 2009 at 1:38 am
Why not re-script them into a single file?
[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]
December 10, 2009 at 1:34 am
Viewing 15 posts - 1,201 through 1,215 (of 7,636 total)