There's a follow-up to this post at the bottom:

http://msdn.microsoft.com/en-us/library/aa337083.aspx

see;

"This post is incomplete! "

section at the bottom.

It's all about the resources on the box(s) - Disk, Memory, cpu.

AND if there are enough resources on a single node to handle a failover if that were to occur.

I've...

I believe the sp_help_revlogin for 2005 generates the SID's for you, so you don't have to worry about orphaned user ids.

Not technically correct:

From: http://technet.microsoft.com/en-us/library/cc917715.aspx

Note: Indexed views are a feature of all versions of SQL Server 2000 and 2005. In the Developer and Enterprise editions of SQL Server 2000...

Indexed Views are only in Enterprise Edition.

and I added another job to remove old backup files......

Another scheduled task to delete old backups:

RUN: forfiles /p "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup" /m "*.bak" /d -7 /c...

I use this method:

http://www.mssqltips.com/tip.asp?tip=1174

It's very easy to use and set up.

lol

Here's a complete article on..

"SQL Server 2005 Row Versioning-Based Transaction Isolation"

http://msdn.microsoft.com/en-us/library/ms345124(SQL.90).aspx

if the 'awe enabled' flag in sp_configure is set to '1', you're good-to-go. Also, the start-up log message you already sent is another indication that AWE is being used....

You do not need to rerun your SQL scripts.

you can execute sp_configure to look at your current running values.

If you only see a few lines, then;

sp_configure 'show advanced options','1'

reconfigure

then sp_configure...

When to use /3GB and or /PAE is confusing: Some other blogs can explain it better than I can.

This one's not bad:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55191

You still need to "lock pages...

Also, need to add the "lock Pages in Memory".

START-RUN , enter - gpedit.msc

Computer Configuration - Windows Settings - Security Settings –

-Local Policies - User Rights Assignment

In the...

At first glance, I think you need to remove the /3GB switch from boot.ini and add the /PAE switch instead.

I'm not sure if anyone's mentioned this yet, but SQL Express, by default, has remote connections turned off. Go into the SQL Server Surface Area Configuration and check the...

go into the SQL Server Configuration Manager. On the left side, click on SQL Server Services. On the right side you will see the account that each service...