Roy Ernest (9/8/2011)

---

Jack Corbett (9/8/2011)

---

Side note, my dad (nearly 80) fell last night and broke his hip. Needs surgery. I'd appreciate prayers as his health is not good...

SpringTownDBA (9/7/2011)

---

short answer:

DB1, min 6-7 GB, unlimited max

DB2, min 3-4 GB, unlimited max

as it is currently configured, you have 40 GB of ram and only 18 GB can be...

Steve Jones - SSC Editor (9/7/2011)

---

mtillman-921105 (9/7/2011)

---

Hmm, just noticed that SQL Server Central t-shirts are on sale here. 'A little pricey at $27.00 though, but I still may pick...

Grant Fritchey (9/7/2011)

---

You all know Gail is on right now? She's doing great:

https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H

I'm going on at 2300GMT or 7:00PM EDT

https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H

You'll get close to 2 out of 7 hours of our...

mtillman-921105 (9/7/2011)

---

Hmm, just noticed that SQL Server Central t-shirts are on sale here. 'A little pricey at $27.00 though, but I still may pick one up. I feel...

The most remarkable about your achievement it that from that number of participations is that more than 99.5% of those...

MiguelSQL (9/5/2011)

---

...

Min Server Memory is set to the same value as Max Server Memory, so I guess I'll have to adjust that value downwards to ensure that both instances can...

regarding how to find out if your instance service account is using "locked pages in memory".

You will find such reference in the instances errorlog file at startup time (may already...

it depends.

How is auditing handled ? ( who did what, e.g. who last modified a row,...)

We use a databases dbgroups. these actually hold the grants. a sqluser is only...

As Perry was trying to state:

dbmirroring doesn't "just" work for applications !

You need to modify the connection objects/strings of every application you want to take advantage of dbmirroring. (unlike clustering...

no, not the domain name, the group name you intended for your collection of sql sysadmins.

( there have been issues with it, although I don't have the refs at hand...

just curious ... Is the domain group name length > 20 chars ?

just for info is this on 32-bit/64-bit ? AWE ?

What's the min server memory settings for the instances, because that's the amount of ram the instance will need at...

juan08 (9/2/2011)

---

Thank you for helping ALZDBA.

The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t...

LutzM (9/2/2011)

---

Thank you Johan for "joining the party"!!! Much appreciated.

Your script should help to narrow it down even further.

One thing I noticed:

In the last section of the script where END...