Viewing 15 posts - 2,611 through 2,625 (of 5,685 total)
Krasavita (9/12/2011)
September 12, 2011 at 1:29 pm
There's one concern with de-normalizing the structure for your boss in regards to views, which I didn't see mentioned (sorry if someone brought this up).
We need to determine why the...
September 12, 2011 at 1:17 pm
Ninja's_RGR'us (9/12/2011)
Not something Joe's been doing AFAIK.
Also while far from perfect, I don't think I have...
September 12, 2011 at 12:29 pm
eccentricDBA (9/12/2011)
Revenant (9/12/2011)
SQLRNNR (9/12/2011)
flameold
retirement
Old flame's retirement home.
September 12, 2011 at 12:07 pm
bcsims 90437 (9/9/2011)
Revenant (9/9/2011)
bopeavy (9/9/2011)
FRIDAY!Beer(s)!
Cheers!
~...where everybody knows your naaaammmmeee....~
(and now it's stuck in my head)
September 9, 2011 at 3:41 pm
YSLGuru (9/8/2011)
September 8, 2011 at 5:04 pm
Find the largest and hardest hit tables, and try to split them from join to join across two filegroups on the different drives. This way you can access two...
September 8, 2011 at 4:31 pm
Couple of things here.
Pages/sec are when you're resolving hard page faults, which since you mentioned your page file, seems to indicate that you're aware of that. However, yes, 350/sec...
September 8, 2011 at 3:57 pm
This Gentleman is looking for some ETL best practices and didn't quite get what I was trying to tell him. Perhaps another voice may be able to assist him...
September 8, 2011 at 3:41 pm
When is the process being run? Which one has more memory available? Are you transforming in the package or after drop to staging tables? Which one has...
September 8, 2011 at 2:03 pm
meichner (9/8/2011)
Thank goodness you don't have to shoot me.
Hehehe!
Let me explain the relationships a little better.
A Customer can have many Shipping/Billing addresses and many Shipping/Billing contacts.
Not a problem...
September 8, 2011 at 12:29 pm
Jack Corbett (9/8/2011)
September 8, 2011 at 11:58 am
meichner (9/7/2011)
September 7, 2011 at 5:57 pm
Roy Ernest (9/7/2011)
Grant Fritchey (9/7/2011)
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours...
September 7, 2011 at 1:12 pm
Trey Staker (9/2/2011)
Stefan Krzywicki (9/2/2011)
We also have a Road Runner that builds nest on people's cars. The other day when I drove in there was a coyote chasing the...
September 2, 2011 at 3:55 pm
Viewing 15 posts - 2,611 through 2,625 (of 5,685 total)