Viewing 15 posts - 5,146 through 5,160 (of 5,678 total)
Brian McGee-355525 (11/1/2010)
Many thanks. That's pretty much what I've always done, except using IsNull instead of Coalesce (is it really faster?)
There's been a number of timing tests out there...
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
November 1, 2010 at 1:18 pm
There's a third option that may may your life easier for concurrency, but will add significant complexity if you're unfamiliar with it.
Use Service Broker.
The basic layout would be this. ...
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
November 1, 2010 at 1:12 pm
That's kinda what we'd end up doing. Part of the reason I'm trying to get to the core of the data is because I'd actually completely rebuild from scratch...
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
November 1, 2010 at 12:44 pm
jamesniesewand (11/1/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
November 1, 2010 at 12:40 pm
Templar,
Trying to turn that into a usable test set and running into some issues. Biggest one is you trimmed (not sure how) some of the PRIMARY KEY builds.
For example:
CONSTRAINT...
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
November 1, 2010 at 12:35 pm
James,
First, nice work on the sampleset and work shown. Helped a lot.
I usually use a variant on your Method 2 and 3, along these lines:
select
et.ExampleTableID,
et.ExampleProduct,
et.ExampleValue as...
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
November 1, 2010 at 12:13 pm
I'm 98% sure it's possible to get you out of the cursor based methodology here. Can you post the DDLs for the involved tables and a bit of sample...
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
November 1, 2010 at 11:56 am
homebrew01 (11/1/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
November 1, 2010 at 11:51 am
HoustonFirefox (11/1/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
November 1, 2010 at 11:28 am
Temp tables and table variables act differently with different scopes.
The CREATE TABLE #tmp is equivalent, in the scope of the script, to CREATE TABLE tbl_table. It's not a singular...
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
November 1, 2010 at 11:12 am
Sounds like parameter sniffing is the culprit, offhand. As mentioned above, the .sqlplan's for your results from the above two items would help determine that.
Also, check out this...
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
November 1, 2010 at 10:58 am
My personal preference is a staging or temporary table to drop the load into. The reason for this is that at any specific point of failure you don't 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
November 1, 2010 at 10:53 am
<--
Hydra... um... noone here has *any* idea why it's slow, though they might have ideas on what you should look for. But, the solution? We don't even know...
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
October 29, 2010 at 11:29 pm
Dang Jeff, much nicer than mine. I'd forgotten that even existed.
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
October 29, 2010 at 9:37 pm
Ricardumus (10/29/2010)
Thank you Craig. While useless, you have helped me. 🙂Now if i could only remember how to mark threads as solved. :-/
Hopefully the answer was useless, and not the...
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
October 29, 2010 at 9:35 pm
Viewing 15 posts - 5,146 through 5,160 (of 5,678 total)