mekal inc (11/6/2007)

---

Excuse me, but it seems that not all of your questions have been answered yet.

See this kb article for info regarding correct memory setting and general info (follow...

russell (10/25/2007)

---

SQL 2005 SE can use as much memory as OS supports.

for more than 4Gb I'll use /3gb and enable AWE, Lock pages in memory

on your 2000 SE instance don't...

That...

Sorry, I don't quite follow you. Could you explain more about the considerations for the system-defined SP's and maintenance...

Paul Randal (10/23/2007)

---

Checkout a series of articles I wrote last year and this year when I was still in MS about running CHECKDB - http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC+CHECKDB+Series/default.aspx

There's also a recording of a...

Jereme Guenther (10/19/2007)

---

I don't know how or if you have time to read all of these posts, but here are my stats.

I obtained a BS in Software Engineering picking up...

Vivien Xing (10/23/2007)

---

In theory as frequently as possible so you can detect the error early (if any). In reality, do you have window to run it every day? ...

Steve Jones - Editor (10/18/2007)

---

Comments posted to this topic are about the item

I decided that this might make a nice Friday poll. So...

What type of degree(s) do you...

Paul G (10/17/2007)

---

It is slightly away from the point of this thread but it would be interesting to know how many people on this site have a degree as well...

sqldba (10/18/2007)

---

/3GB switch as nothing to do with RAM. this /3GB switch is for VAS(Virtual Address Space) so by having this switch in boot.ini your kernel mode will get 1GB...

Thanks for your reply. Just...

Steve Jones - Editor (10/16/2007)

---

The absence of a degree does not imply any lack of skill, knowledge, intelligence, or anything else. If it's not there, ignore it and focus on...

colin Leversuch-Roberts (10/16/2007)

---

there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way...

Hi Steve,

Someone pointed this out yesterday, but it happened again today. There's been no category for the last two questions.

webrunner

College is extremely important, but not necessarily in the way people expect. A college degree is the new high school diploma. It allows a person to have a wider range...