Try setting the max degree of parallelism to something other than default. I've seen sql server max out all cpu's and cause connection problems.

EXEC sys.sp_configure N'max degree of parallelism',...

Cough, Cough

bteraberry (7/21/2010)

---

I can't say why it's different before and after the cumulative update, but I can tell you that this is generally a problematic way to query data.

Doing any kind...

http://www.sqlskills.com/BLOGS/PAUL/category/Inside-the-Storage-Engine.aspx

Compression doesn't appear to work on nvarchar(max).

Jason Shadonix (4/22/2010)

---

ben.rosato (4/22/2010)

---

I have a table that's 10GB. There is a ntext column that holds the largest portion of the data. When I check the estimated compression...

I have a table that's 10GB. There is a ntext column that holds the largest portion of the data. When I check the estimated compression for this table...

ken.trock (4/16/2010)

---

You're kidding, right? You don't really have a heated indoor olympic size heated pool, do you? I thought we had everything health-wise at my company and I tease our...

Ben Moorhouse (4/16/2010)

---

A kettle that we're allowed to use in the office!

This would be both a nice gift and a way to save money by not going to Starbucks :)...

Steve Jones - Editor (2/23/2010)

---

Did it work?

The newsletter likely is caught in a filter. We recently adeded the DKIM flag to it, which Yahoo, Hotmail, GMail want, but other than...

Ben Thul (1/18/2010)

---

I think to truly support walls in the middle of the grid, you'd need to change how you encode the maze. I thought of one such encoding...

Bill Talada (1/15/2010)

---

To keep the code sample very small, I cut some corners. The code that "looks" at the surroundings of the robot assumes a square border around a...

jeremiah.thomas (1/14/2010)

---

I think i am with Valued member. how do we read the grid that decipherDNA creates?

here is a short example of the grid:

n s e w c a

0 0...

Bill Talada (1/14/2010)

---

If you run the included "DecipherDNA" script and do a "select *" at the bottom of it, you will see all 243 possible views numbered. These...