Search results

Hi all, I was wondering if anyone here had experience diagnosing some SQL Server deadlock I have recently run into, or if anyone has encountered this problem before on other databases. The situation I have run into is that of a SELECT query blocking an UPDATE query, and the UPDATE blocking...

I have run into a problem - I am in the process of writing a module that will ensure each table in our database schema has the correct primary key column(s) set. The first iteration I wrote does this under MySQL and now I am set to tackle MS SQL. However, I have run into a problem. MySQL...

I am currently involved in a friendly debate with a coworker over whether or not using a query that contains multiple LEFT JOIN statements will have any significant performance impact. Here is some background: There are certain parts of our code that simply need to check if something...

I am working on a content management webapp. I have one instance of a folder with a large amount of content in it (2500 pages), and I am noticing that when I load that folder in SQL Server the CPU on my machine spikes for 15-20 seconds while rending the folder content. All of the content is...

Hi all, Just got my htpc setup...running very nice thanks to all the advice I've read here on the forum! I have a Hauppage PVR-500 in there right now with Media Center 2005 running on it, and I'm just having one problem: two of the channels have bad to very bad reception. The channels are...

Hello folks, That's right, this may seem a little weird, but I'm breaking the asus p55t2p4 out of retirement and putting a k6-2 500mhz in it. (google asus p55t2p4 for more info, I'm not going to link to the hardware review site that has the info on this since they're in competition with [H]...