Viewing 15 posts - 1,036 through 1,050 (of 7,631 total)
Then, unless it had all optional parameters, the tutorial was wrong. Service Broker passes no[/b] parameters to the activation procedure, so if it requires any, the activation will fail.
[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]
February 9, 2010 at 8:01 am
kambanjet (2/8/2010)
I would like to ask for help on setting up auditing in SQL 2005 for any updates, deletions, and insertions done through the back-end or through SQL...
[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]
February 9, 2010 at 7:51 am
Bob Hovious (2/9/2010)
The Dixie Flatline (2/8/2010)
Oh sweet mercy..... Barry is really my own self from an alternative universe?!I feel smarter already !!
Crap! My wife just...
[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]
February 9, 2010 at 7:41 am
OK, I think that there is a very important conceptual block that you must address first, before you can ever be comfortable with this. Let's start here:
Dave Winchester (2/9/2010)
[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]
February 9, 2010 at 7:14 am
Barkingdog (2/9/2010)
1....
[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]
February 9, 2010 at 5:57 am
BrainDonor (2/9/2010)
It took me...
[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]
February 9, 2010 at 5:51 am
The Dixie Flatline (2/8/2010)
Oh sweet mercy..... Barry is really my own self from an alternative universe?!I feel smarter already !!
Crap! My wife just called me "Bob"!...
[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]
February 9, 2010 at 5:33 am
CirquedeSQLeil (2/8/2010)
Bob Hovious (2/8/2010)
Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC...
[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]
February 8, 2010 at 9:35 pm
[h2]Urgent![/h2]
Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font], but something has...
[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]
February 8, 2010 at 8:43 pm
Dave Winchester (2/8/2010)
My main question was surrounding the design of many comment tables - I read a book about SQL Database Design and it made it clear that normalisation rules.
Yes....
[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]
February 8, 2010 at 6:46 pm
(Oops, bad post. Please ignore)
[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]
February 8, 2010 at 4:21 pm
I fixed up the other function as it had some problems too (two parameters it wasn't using, really inefficient statement structure, etc).
ALTER FUNCTION [dbo].[DebtorProfileGet_New] (@TotalPaid float, @TotalDue float) RETURNS int...
[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]
February 8, 2010 at 4:08 pm
I also cleaned up one of the two functions as it had a lot of issues (an internal cursor, and referencing that missing table). Its not valid without 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]
February 8, 2010 at 4:03 pm
OK, I had nothing better to do today, so I went through and pared your proc down by 1) reducing the number of output tables from 6 to 3, 2)...
[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]
February 8, 2010 at 3:58 pm
I should add also, that if multiple tables are treated in a logically identical way in the proc, then should also be able to eliminate the logically redundant tables.
[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]
February 8, 2010 at 9:05 am
Viewing 15 posts - 1,036 through 1,050 (of 7,631 total)