Viewing 15 posts - 4,591 through 4,605 (of 7,631 total)
This should do it:
ALTER PROCEDURE [dbo].[sp_PRBMoneyReturned] AS
BEGIN
DECLARE
@ROW1 int,
@ROW2 int,
@TRANNO1 int,
@TRANNO2 int
SELECT ROW_NUMBER()...
[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 1, 2008 at 9:02 pm
I don't think that an Indexed View can be based on GROUP BY, can 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 1, 2008 at 8:08 pm
OK, I have looked through your procedure a few times and I do not see anything wrong, but it probably does not scale very well.
I would say that there 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]
December 1, 2008 at 3:53 pm
gardenlady (12/1/2008)
FROM #nisse WITH (INDEX(IX_TransHist_AccountID_Date))
Why did you add this? I do not believe that you can use INDEX hints anywhere but in a SELECT....
[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 1, 2008 at 3:15 pm
Bob Abernethy (12/1/2008)
And then there are those people who irrationally hide surreptitous dogma...
Amen to that, brother.
[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 1, 2008 at 3:03 pm
Daved is right. There are, however, some things that you can do to "encourage" it to run in Clustered index order. This this:
DECLARE @RowNum int
UPDATE...
[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 1, 2008 at 2:17 pm
Sure, I use them all the time, however, we were just trying to fix the OP's query, with minimal change.
[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 1, 2008 at 12:39 pm
Well that looks OK too.
I am afraid that I've reached the limits of my expertise. I would suggest taking a look at the Security & Network settings on the...
[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 1, 2008 at 12:35 pm
rbarryyoung (12/1/2008)
Sorry, two more:
select * from sysmail_profileaccount
select * from sysmail_principalprofile
Were you able to get these yet?
[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 1, 2008 at 12:20 pm
sgardner (12/1/2008)
[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 1, 2008 at 12:09 pm
This is a different question. You should start a new topic.
[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 1, 2008 at 11:44 am
awinter (12/1/2008)
I see your points on deadlocking. We'll leave that part out of the discussion for the sake of simplicity. My main objective was to see if there's...
[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 1, 2008 at 11:21 am
OK, so far everything looks OK. The only odd things that I noticed were the port 587 and [enable_ssl]=1 settings on your gmail.smtp server. I assume that both...
[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 1, 2008 at 10:57 am
Sorry, two more:
select * from sysmail_profileaccount
select * from sysmail_principalprofile
[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 1, 2008 at 10:55 am
OK then, execute the following commands and show us the results:
select * from sysmail_account
select * from sysmail_profile
select * from sysmail_configuration
select * from sysmail_server
select * from sysmail_servertype
Also, I need confirmation 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]
December 1, 2008 at 10:13 am
Viewing 15 posts - 4,591 through 4,605 (of 7,631 total)