Paul, I have been away for a few days, hence the delay in my posting!

You have certainly not confused me further. Thanks very much for the detailed response, and for...

Paul White (5/28/2009)

---

Lynn Pettis (5/21/2009)

---

You don't need AWE enabled to access more than 2 GB of RAM on a 32-bit OS...we just needed to add the /3GB switch to the...

I thought your question could be paraphrased as 'please give me a presentation on what a DBA does?'

I don't agree that this is what this site is for.

What I think...

balbirsinghsodhi (5/27/2009)

---

I was told by my boss that I have to do powerpoint demostration about DBA work to the users in our company.

Actually, we are doing some kind of...

You can't insert the results directly into a table because you have two different results sets (and so two different tables).

In SQL Server 2005 upwards these results are generated from...

What I've learnt from this thread is:

(1) When using windows, there are good techical reasons for using a password of 15 or more characters because they are less esily compromised...

Alex, Michael, you are both correct.

And in hindsight I regret the way I phrased my comments to you.

Sorry.

Tim

You didn't post your database size. But here are my comments.

Michael Valentine Jones...

kompwiz (5/20/2009)

---

I am having a strange dilemma where the page life expectancy counter is dropping to around 200-300 every hour or so.

The available memory at that time is...

I agree 100% with Jeffrey Williams.

Your transaction log grows to the size it needs to be in normal use. If you have utility jobs (e.g. Defragmentation) then this is still...

You have good solid advice from george in the posts above.

How did your boss get so worried about this? In 20 years plus experience I never had anyone worry this...

Thanks Michael, there are a few nuggets in there...

Tim

paul.knibbs (5/20/2009)

---

The reason for the 14-character password in Windows things comes down to the old LanManager password hashes Microsoft used to use, which would split the password into two 7-character...

Ewan, that's interesting, and I entirely agree about password length.

MATHS:

My example at the top of the thread was word-number-WORD-number-word.

Now if I tell a hacker I use three words from the...

Thats a fair point, apologies for the incomplete information in my previous post.

Tim