Thank you, do you know...

colin Leversuch-Roberts (6/16/2008)

---

No, wish it were that easy. I find it all very interesting, sadly, but the optimisers are so different that some queries run so much...

colin Leversuch-Roberts (6/16/2008)

---

Well given a box with 4gb of ram if you want to play with the memory you can either enable the 3gb switch or enable awe and set...

Jeff Moden (6/14/2008)

---

Marios Philippopoulos (6/14/2008)

---

CLR is useful in such cases as these (benefit in parentheses):

- string manipulation, regular expressions etc. (performance)

- OS-level operations, previously possible only using xp_cmdshell (more granular...

CLR is useful in such cases as these (benefit in parentheses):

- string manipulation, regular expressions etc. (performance)

- OS-level operations, previously possible only using xp_cmdshell (more granular security, functionality with...

Carl Federl (6/14/2008)

---

This message is related to the network.

Check the NIC setting on both servers and insure that "link speed & autodetect" is NOT "auto-detect" and that the other...

Yes,...

Chris.Strolia-Davis (6/13/2008)

---

while (select count(*) from @table) > 0

begin

select top 1 'do something', @id=id from @table

delete from @table where id=@id

...

This scenario is a perfect shoe-in for SCOM (System Center Operations Manager 2007).

SCOM is the perfect tool for monitoring this and a myriad other aspects of your server's daily existence.

abhay.kulkarni (6/13/2008)

---

Creating a table variable is in the memory, not in the tempdb and hence much more efficient. Of course if you have truckload of data, you better use a...

It's very dangerous and counterproductive choosing one technique over another based on bias alone.

Let's call this total aversion to cursors just what it is, pure cursorism, and people espousing it...

Thank you AndyD for the very valuable info.

Wow, I'm still trying to wrap my head around memory architecture and what all the terms mean...

These are not easy concepts to master...

Paul Randal (6/9/2008)

---

Parallelism doesn't have anything to do with it on 2005. The problem comes because of a disk or memory corruption that alters a page ID (2-byte file number...

For us it only occurred once on 2008-06-04.

Any info on this you can find, please post it.

Also, unless yours is strictly an instance used for reporting with very little OLTP,...

Jack Corbett (6/6/2008)

---

Wish I could help more, but I can't find anything related to this error in SQL 2005. Found lots of stuff for SQL 2000 though. I...