Viewing 15 posts - 1,456 through 1,470 (of 5,504 total)
If this process is as complex as you describe and you can't narrow it down to a few queries I'd recommend to get a consultant in analyzing your system. A...
May 31, 2011 at 3:37 pm
I recently took the test for CUI (on a test system, of course). But due to the sheer amount and the excellent taste of the liquor served, it rapidly turned...
May 31, 2011 at 1:10 pm
SC48035 (5/31/2011)
May 31, 2011 at 12:53 pm
GSquared (5/31/2011)
...GSquared, OEC, FEBC, HDA, RSVP, OODA, MAP, NMVP, ARCSW, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ETC
Gus, you didn't take the...
May 31, 2011 at 12:49 pm
I'm not sure if the query itself got "transported" properly since it looks like there is no join between MainDistricts/offices on one side and the Customers "join group" on the...
May 31, 2011 at 12:31 pm
At a first glance I thought it's a running total problem, too. But I'm not sure anymore. It might be possible to do it all set based. But I'd need...
May 31, 2011 at 11:00 am
4.5mill rows is still not "large" for some of us.... 😉
If you could provide the actual execution plan for the two heaviest queries we migt be able to give you...
May 30, 2011 at 1:46 pm
It actually doesn't make sense to me: why don't you just store the customer specific product name together with your internal product name in a separate table? Then you wouldn't...
May 30, 2011 at 12:46 pm
Is this just a single query taking 20 minutes?
500k rows is not really that much...
If it's just a single query, can you post the actual execution plan?
May 30, 2011 at 12:31 pm
If the destination table has a NOT NULL constraint on the remaining two columns you need to insert the related values.
Please talk to the DBA in charge what values are...
May 30, 2011 at 12:15 pm
Additionally to the PIVOT recommended above you could use the good old CrossTab approach.
For an example please have a look at the related article referenced in my signature.
May 30, 2011 at 12:08 pm
Syed Jahanzaib Bin hassan (5/30/2011)
@"Mr. Alphabet Soup":
It starts to get annoying to see replies with the "answer" being a lot shorter than the alphabet soup under your name. Sometimes you're...
May 30, 2011 at 10:04 am
The link I provided was to demonstrate how to narrow down the issue.
Did you try finding other web references for the other error codes you posted?
May 30, 2011 at 9:40 am
subrata.bauri-1051938 (5/30/2011)
kindly reply
Please note that we are all volunteers and we're not spending each and every minute waiting to reply on a post. Asking for an answer just 15 minutes...
May 30, 2011 at 7:44 am
Viewing 15 posts - 1,456 through 1,470 (of 5,504 total)