Add /PAE to the boot.ini. Grant locked pages, enable AWE.

/PAE - allow memory usage above 4GB (32 bit limit)

/3GB - change the kernal/user memory division from 2GB/2GB to 1GB/3GB.

Waits over a period of a year aren't all that useful, too low a granularity. When doing wait type analysis, you usually look at the difference between the waits a...

gregrobson (3/12/2013)

---

Thank you GilaMonster... the force is obviously with you judging by your avatar.

Worked out the fix. Your note to check the ports prompted me to find that.

1) I hadn't...

If you're splitting into files and filegroups, the first thing you need to do is decide whether you're splitting for IO load or splitting for DR and recovery purposes. The...

SELECT * FROM mstinstrument where instrumentid IN (@intid); is equivalent to

SELECT * FROM mstinstrument where instrumentid = @intid;

So looking for

SELECT * FROM mstinstrument where instrumentid = '''BSEC0002'',''BSEC0001''';

Should be clear...

Go to configuration manager, stop the SQL Express instance (leave the others running) and try to connect again to those 3 new instances. Restart SQL Browser too.

Also, go to the...

Why are you encrypting? What are you protecting against?

With server maxdop 0, SQL has the option of using up to all of the processors for any operation (including the index rebuild). If you specify maxdop = processor count...

Lynn Pettis (3/11/2013)

---

Same could be said ot their CRM...

There's easier ways to get back into an instance that you've locked out. Start SQL in single user and any local admin is sysadmin, no traceflags required.

Communication? What a novel idea!

The sharepoint DB needs a complete redesign first, and to be honest, that's not going to happen.

No isolation level will help there. To restore the process needs an exclusive database lock, that means all users out. You can set log shipping to automatically disconnect everyone or...

Dunno about the law where you are, but there's often a difference between taking a copy for personal use (backup) and distributing copyright material to someone else. It was the...

Not to be a downer... but the material for those courses is copyrighted, just like training kit books and other publications.

Well I didn't say run them manually...

If you want server 4 to be able to run server 3's jobs when server 3 fails, then you need to have those jobs...