Viewing 15 posts - 3,856 through 3,870 (of 5,685 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...
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...
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,...
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...
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...
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 + ' ' +...
March 1, 2011 at 3:03 pm
amenjonathan (3/1/2011)
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 -...
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,...
March 1, 2011 at 12:16 pm
dndaughtery (3/1/2011)
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...
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...
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...
March 1, 2011 at 11:13 am
Jeff Moden (2/28/2011)
Craig Farrell (2/28/2011)
.... AAAAaaaaand I'm in...
February 28, 2011 at 6:23 pm
Jeff Moden (2/28/2011)
Craig Farrell (2/28/2011)
February 28, 2011 at 6:00 pm
Viewing 15 posts - 3,856 through 3,870 (of 5,685 total)