Only one statement in the batch.

I added about 10gb to the database about 2hrs before this statement started. I'm assuming that's enough time for the lazywriter to 0 out...

Here is the result of 5 snapshots of the relevant columns of sys.dm_exec_requests. I don't see any blocking. It just appears from what I can see that it's...

It has been running for 18 hours total. This is from the time that I hit Execute. So I am guessing that it has been processing the rows...

I have seen where people are encouraged to turn off their antivirus programs for better game performance on Steam, but I don't think I'll try that one (but I know...

UMG Developer (9/27/2010)

---

I'm not sure you can. If you have the Enterprise version of SQL Server you could use the resource governor to set the MAXDOP for the users connection,...

That's what I figured. How could I setup MAXDOP on a query that a user runs? I was just going to setup a view on the table that...

2 questions -

1. "Including the partitioning key" - do you do...

alen teplitsky (8/20/2010)

---

been building on and off since the 1990's but it's not really fun anymore with everything being integrated and things like the computer being quiet being more important...

alen teplitsky (8/18/2010)

---

looking to buy a new PC as well

I've thought of an iMac but still thinking about it. downsides are flaky OS X support for Flash and gaming. the...

http://www.newegg.com/Product/Product.aspx?Item=N82E16820227528

It's actually only $150 after rebate and the speeds are 285/275. This is the same one I ordered from the same place. I have Win 7...

I have asked for this thread to be deleted, so if it disappears and you guys are wondering, that's why. Thanks for all your help.

That's a good size for a SSD drive, but those speeds are a little slow for that price. I would opt for a little smaller, since it's a boot-drive...

I understand waiting till the price comes down, but it's totally worth buying one to use as a boot drive. Seriously, my win 7 machine boots up in less...

To get the most out of SSD, you have to have a newer motherboard. Pretty much any of the new ones will have an APHC mode (prob a typo...

tosscrosby (8/13/2010)

---

Will Summers (8/12/2010)

---

How does everyone deal with a coworker who's lazy, lacks listening skills, lacks logic skills, lacks technical knowledge, lacks initiative, talks slow, walks slow, can't...