Viewing 15 posts - 3,856 through 3,870 (of 5,678 total)
sqldba_icon (3/1/2011)
DO you know of any good affordable performance tuning consultants?
There's a number of them (us?) around here, Gail being one of the best around here. As she already...
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
March 1, 2011 at 4:35 pm
Okay, roughly the same comment, just with Foreign Keys added:
You've only got the one index on the fact table, owch. That table's roughly 250-300 bytes wide, and this is...
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
March 1, 2011 at 4:12 pm
:blink: You've only got the one index on the fact table, when she's that wide? Owch.
CONSTRAINT [PK_fact_tes_transac] PRIMARY KEY CLUSTERED
Definately try adding in the NC index I mentioned above,...
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
March 1, 2011 at 3:24 pm
dndaughtery (3/1/2011)
Execution plan attached
Couple of things...
Any chance you can post the DDL and indexes of fact_transac? It looks like a missing index might help you out there.
This is 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
March 1, 2011 at 3:17 pm
tshad (3/1/2011)
Is there a way to read an xml file or configuration file to get the Data Source values since they could change?Thanks,
Tom
Some data source values, yes, like filepath or...
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
March 1, 2011 at 3:06 pm
I didn't dig through the entirety of your problem, but you cured the most painful component which seems to be your concern, which is this:
and pm.policyid + ' ' +...
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
March 1, 2011 at 3:03 pm
amenjonathan (3/1/2011)
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
March 1, 2011 at 2:26 pm
dndaughtery (3/1/2011)
Using the lookups took 31 min 15 seconds. Using the joins on the server took 45 minutes.
Hm, 1/3 time reduction, very nice.
Tbl1 - 1,185,884 records
Tbl2 - 202 records
Tbl3 -...
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
March 1, 2011 at 2:17 pm
riyaz.mohammed (3/1/2011)
The requirement is to find records that ONLY have a sale of item 1063. So ONLY orders that have ONLY tem 1063.
Ah! I misunderstood that the first time,...
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
March 1, 2011 at 12:16 pm
dndaughtery (3/1/2011)
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
March 1, 2011 at 12:03 pm
insert into orders (oid, itemid)
values (1,'1063')
insert into orders (oid, itemid)
values (1,'1063')
insert into orders (oid, itemid)
values (1,'1064')
insert into orders (oid, itemid)
values (2,'1063')
insert into orders (oid, itemid)
values (2,'1063')
insert into orders (oid, itemid)
values...
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
March 1, 2011 at 11:58 am
There's another option, and it's in stream without a VB component, but does require some repetitive coding and usage of expressions. You'd have to used the derived column component...
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
March 1, 2011 at 11:53 am
WayneS (3/1/2011)
GSquared (3/1/2011)
Kiara (3/1/2011)
Brandie Tarvin (3/1/2011)
How 'bout I throw some high heels, a mini skirt, and a lumberjack into the mix to really leave you screaming for the brain bleach?@=)
"I'm...
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
March 1, 2011 at 11:13 am
Jeff Moden (2/28/2011)
Craig Farrell (2/28/2011)
.... AAAAaaaaand I'm in...
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
February 28, 2011 at 6:23 pm
Jeff Moden (2/28/2011)
Craig Farrell (2/28/2011)
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
February 28, 2011 at 6:00 pm
Viewing 15 posts - 3,856 through 3,870 (of 5,678 total)