> So, the step taken by LiveDrive to close our customers' accounts without refunding us is totally illegal, and we are considering our legal options at this time. Since your account was already paid fully for one year in advance, we request you to get in touch with LiveDrive and ask them to restore your service
Anyway I've been backing up to Crashplan the past two days, so just need to make sure I get that HDD replaced, since backing up external HDDs to it is iffy
BTW I like Google+ already, because apparently even geek.com used my post for their blog post :P
I generally keep my laptop on 24x7, and at the end of the day it's really annoying to have my thighs burnt because over overheating.
The overheating seems to be a result of WMI Provider Host (WmiPrvSE.exe) spiking the CPU utilization to 25% every few minutes. Why does this happen?
I have an H...
Very occasionally, about once a week, my Windows Vista Business machine will completely lock up for anything between a minute and several minutes. Once this happens, it recurs more frequently until I reboot.
Process Explorer reveals that during this event, the system is performing "Hardware inte...
Oh god, @Sathya what was the problem with Sandy Bridge motherboards again?
> If this reads “REV_04” as in the provided example, then your motherboard is based on the B2 revision of the Cougar Point chipset and is affected by the SATA 3Gbps bug, otherwise you are in the clear.
when my GF tried watching Desperate Housewives the video sometimes would just stop
@Sathya here's a quiz for you
Consider the following SQL table declaration:
CREATE TABLE Emps (id INT, ssNo INT, name CHAR(20), managerID INT);
We would like to extend the table declaration to enforce that each of id and ssNo is a key (by itself), and each value of managerID must be one of the values that appears in the id attribute of the same table. Which of the following is not a legal addition of SQL standard key and/or foreign-key constraints? Note: The addition does not have to achieve all of the stated goals; it only must result in legal SQL.
Add "UNIQUE" after each of the first two INT's.
Add "PRIMARY KEY" after the first INT, and add "UNIQUE" after the second INT.
What are the rules for adding unique and primary keys to a table declaration
Add ", FOREIGN KEY (managerID) REFERENCES Emps(id)" before the closing parenthesis.
Add "UNIQUE" after each of the first two INT's.
Add "PRIMARY KEY" after the first INT, and add "UNIQUE" after the second INT.
Add "PRIMARY KEY" after the first INT, and add ", FOREIGN KEY (managerID) REFERENCES Emps(id)" before the closing parenthesis.
Oh wait I had Primary Key in another answer, not Foreign key
> This choice is correct SQL. We have set up a primary key and a foreign key that references it. This change does not satisfy the desire to make ssNo a key as well, but as the question states, we only ask that you identify legal SQL.
Your answer Score Choice explanation
Add "PRIMARY KEY" after the first INT, and add "REFERENCES Emps(id)" before the closing parenthesis. 0.00 This choice is correct SQL. We have set up a primary key and a foreign key that references it. This change does not satisfy the desire to make ssNo a key as well, but as the question states, we only ask that you identify legal SQL.
woops for unreadable
but this version has "PRIMARY KEY" not "FOREIGN KEY" and that was valid
Very occasionally, about once a week, my Windows Vista Business machine will completely lock up for anything between a minute and several minutes. Once this happens, it recurs more frequently until I reboot.
Process Explorer reveals that during this event, the system is performing "Hardware inte...
> After some digging it turns out they are related to the "Hardware Interrupts and DCPs" process. One of the first hits on Google pointed out that this could be related to S-ATA issues haunting the first batch of Sandy Bridge motherboards.
Hardware Interrupts and DPCs is not a process but a part of the kernel consisting of interrupt routines and drivers handling deferred procedure calls. If you throw that name into Google you might get about any problem related to CPU usage and drivers.
It's SATA-related. The Cougar Point problem specifically affects the motherboard's SATA controller, causing onboard SATA ports to degrade over time and possibly reduce performance of hard drives, optical drives, and other SATA-driven devices.
Most system freezes (where you can't use hot-keys like CTRL+ALT+DEL) are caused by hanging drivers,
so you will have to either replace the device or update the driver. Troubleshooting can be done:
Download the setup from Windows Performance Analysis Tools for your Windows version.
Install the s...
I should probably change my answer to match the "slowness" in the title, it doesn't necessarily need to hang... ^^
I've been doing some upgrading, so this means I have some extra PCI Express video cards. They are not too shabby, either.
ATI 5780 1GB
ATI 5780 1GB
ATI 5770 1GB
Now, the two 5780 cards are still fairly high end and require two 6-pin power connectors. But the 5770 only requires one 6-pin conne...
I generally keep my laptop on 24x7, and at the end of the day it's really annoying to have my thighs burnt because over overheating.
The overheating seems to be a result of WMI Provider Host (WmiPrvSE.exe) spiking the CPU utilization to 25% every few minutes. Why does this happen?
I have an H...
Most system freezes (where you can't use hot-keys like CTRL+ALT+DEL) are caused by hanging drivers,
so you will have to either replace the device or update the driver. Troubleshooting can be done:
Download the setup from Windows Performance Analysis Tools for your Windows version.
Install the s...
I've been doing some upgrading, so this means I have some extra PCI Express video cards. They are not too shabby, either.
ATI 5780 1GB
ATI 5780 1GB
ATI 5770 1GB
Now, the two 5780 cards are still fairly high end and require two 6-pin power connectors. But the 5770 only requires one 6-pin conne...
