Viewing 15 posts - 3,286 through 3,300 (of 7,631 total)
Derek Dongray (3/20/2009)
And from his description of his setup (sync software + 3 application tools + 5 databases), I don't think changing...
[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]
March 20, 2009 at 3:44 pm
Show us what you are actually using now.
Are there any other triggers on the table?
[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]
March 20, 2009 at 12:15 pm
Why do you want to do this? What are you hoping to accomplish?
[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]
March 20, 2009 at 12:09 pm
OK, nothing apparent so far. I think that you will need to setup a profiler/trace collection on this SSIS connection and capture all of the SQL commands/procs/statements. Somewhere...
[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]
March 20, 2009 at 12:04 pm
My office is in Claymont. One of my best friends grew up in Hockessin and still lives there.
OK, right off the bat: I see 3 dysnamic queries, but you...
[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]
March 20, 2009 at 10:01 am
Greg J (3/20/2009)
I have NO GOTO statements in the sproc!
The error is not about GOTO's it is about labels. It is probably malformed dynamic sql, but that is not...
[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]
March 20, 2009 at 9:54 am
Thanks, Gus. I came up with that fix on my own. Adam Machanic, Ward Pond and some others have a different solution that they use (don't have 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]
March 20, 2009 at 9:04 am
Also, we will need to see the listing of the "usp_rtrh" stored procedure.
[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]
March 20, 2009 at 9:00 am
Greg J (3/20/2009)
INSERT INTO a2db_rawhistory.dbo.tx_wb5asc ([WBKEY], [RECNO], [SEGMENTCOUNTER], [TUBINGINCHES], [TUBINGFRACTIONNUMERATOR], [TUBINGFRACTIONDENOMINATOR], [DEPTHSET], [PACKERSET], CurrentAsOf)
SELECT r.[WBKEY], r.[RECNO], r.[SEGMENTCOUNTER], r.[TUBINGINCHES], r.[TUBINGFRACTIONNUMERATOR], r.[TUBINGFRACTIONDENOMINATOR], r.[DEPTHSET], r.[PACKERSET], 'Mar 20...
[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]
March 20, 2009 at 8:59 am
The order of insertion has no deterministic relationship to the order that records are physically stored. The only functional order in SQL is that imposed by a Top-Level 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]
March 20, 2009 at 7:07 am
Just a point, AFAIK, tables and indexes can only be allocated to FileGroups, not mere Files within those FileGroups.
If you add a new file within an existing group, SqlServer should...
[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]
March 20, 2009 at 6:56 am
Like this:
select sys.table.name as [Table
Name] from sys.tables
(I have to admit, I have never tried, seen or even heard of this one before! :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]
March 20, 2009 at 6:49 am
I always use your method #2, which we call "Wrapper" functions/procs, etc.
[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]
March 20, 2009 at 6:38 am
You can also just right an Agent Job that refreshes all of the views once a night or every couple of hours. Low-tech, but I used to do 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]
March 20, 2009 at 6:31 am
OK. Well, good luck then.
[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]
March 19, 2009 at 11:43 pm
Viewing 15 posts - 3,286 through 3,300 (of 7,631 total)