Viewing 15 posts - 4,591 through 4,605 (of 5,678 total)
Each instance, or server, needs its own endpoint.
You'll also need to generate the route on each side to the other, so you can send close dialog messages and the like.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 12, 2010 at 11:29 am
Paul, thank you.
Please don't feel I'm ignoring your comments if I don't provide an immediate answer on this while I wrap my head around all the information and recommendations.
The first...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 12, 2010 at 11:25 am
For an instance of WHEN to use it, an example would be conditional flowing. By enabling/disabling different containers, you can have your script task perform an If/Then structure that...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 12, 2010 at 2:14 am
You need to setup endpoints.
The best Service Broker basics/walkthrough I've seen, by Adam Machanic:
http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/
http://www.simple-talk.com/sql/learn-sql-server/service-broker-advanced-basics-workbench/
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 12, 2010 at 2:13 am
WayneS (12/11/2010)
Just a W-A-G here, but since you're posting in a SQL 2005 forum, I'm guessing that you're also using SSMS 2005?
Dead on target.
Also, take a look at those...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 10:04 pm
Paul White NZ (12/11/2010)
Thanks for that, it helps a great deal. Just one more question before I get to the good stuff.
The delta/replacement files you get for historical edits:...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 10:01 pm
WayneS (12/11/2010)
Any chance of getting an execution plan on that first update (the 6 hour one)? Also, can we get updated Delete/Insert/Update plans after you implement the 3rd suggested index...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 6:18 pm
WayneS (12/11/2010)
Edit: Whoops, this plan is for the update in the cursor, not the initial 6 hour one. Still, it is taking about 8 minutes per batch - this index...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 6:16 pm
Paul White NZ (12/11/2010)
I've spent a good bit of time looking at the script and the execution plans. There's a fair bit to say about them at face value,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 6:10 pm
Paul White NZ (12/11/2010)
Which edition of SQL Server is this? Standard?
Enterprise afaik. I'll double check Monday when I'm back in the office.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 11, 2010 at 3:33 am
WayneS (12/10/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 10, 2010 at 5:35 pm
You've got the idea. I personally would delete from the bottom tables up, just so when you do get around to properly putting in foreign keys this doesn't break.
Your...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 10, 2010 at 5:12 pm
Sighs.
CELKO (12/10/2010)
There is a lot of dialect in this code. SQL uses <> instead of <>,
Typo, he meant <> instead of !=, and he's right.
TOP(n) is proprietary, and you have...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 10, 2010 at 4:47 pm
Take a look into full text indexing. This is probably your best bet for speed here, though it does require some upkeep.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 10, 2010 at 3:51 pm
Oval?
We really need more information here.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 10, 2010 at 3:45 pm
Viewing 15 posts - 4,591 through 4,605 (of 5,678 total)