swe40

Hi everybody! I'm studying for level 3 and find occaisonal group study sessions can be helpful. Anybody interested in meeting up to study in San Diego? Preferably level 3, but all are welcome. Could meet near downtown, UTC, or north inland.

My simple query took 54 minutes and I'd like to hear some thoughts on how to improve it. The first table was a list of the 200 accounts I was interested in. I wanted to know if those accounts were ever in a particular status, so I joined it with our DW's dim_account_hist table (history of dim_account using effective/expiry dates + current flag). That table has approx 25mil distinct accounts, and the total records with details for any point in time add up to 750 mil rows.

Select distinct h.account#
From server2.DW_name.dbo.histtable h
    Join server1...mylist m on m.acct = h.acct
Where h.status = 'ABC' and 
EffectiveDt > '20140701'

One problems is the two databases

I recently pulled my old computer (2006 build, slight upgrades in 07 and 08) out from storage (sat there two years) and now it's having trouble working with my display properly.

It originally worked for about a night and then when I woke up the video wasn't working. A few days later I got it working again using a DVI to VGA adapter, but it didn't get very far before not working anymore (windows was loading but not sure if it went to desktop).

The computer has an Athlon 64 X2 4600+ on this mobo running Win7 32-bit. I can't connect to the mobo so I try using the two DVI ports on my [8800 GT](http://www.newegg.com/Product/Pr

I wanted to point out a problem that I assume many people eventually have when trying to purchase the parts they've selected. As many of us know, there are great deals on CPUs from Microcenter. However, I think there are also tons of people who don't realize these prices, which are about $50 less than almost anywhere else, have to be picked up locally from a Microcenter store. This store isn't that common, there are only 23 stores across 16 states, and so people will often end up $50 over their estimated cost.

I don't know what a solution would be, but I'm hoping a greater general awareness should help people have a more accurate estimate of how much they will end up spending. Maybe PCPartP