The best practice is to create a Windows group to hold all the DBA accounts. Grant this group login rights to SQL Server and add it to the Sysadmin...

The SQL Server 2008 install even has an option to specify where you want tempdb to be placed, so you can separate it from your other databases at install time.

Apologies, I got my SQL versions mixed up. However, there are fixes for AWE issues post SP2, but nothing that is pervasive.

Try asking for less memory when you start SQL Server. If you ask for more AWE memory than what is available to don't get any of it.

Also make sure...

Some tests done where I work now show about a 5% penalty time and CPU penality in using Litespeed encryption, but backup size is has less than 1% difference, compared...

Did you see the bit in my post about Task Manager not showing memory use above the 4GB line? ...

The Windows Task Manager on a 32-bit server only ever knows about memory use below the 4GB line, so it will never show you how much AWE memory is in...

I agree with Michael.

In the early days of databases, IMS got man to the moon in a hierachical fashion. IMS is still around and scales to any size you...

I think my results and rudy's results show that backup performance is affected by how your server is configured. You probably need to try various options and find the...

Jeffrey - thanks for the update, I had missed that one!

Krishna, ...

Or 6-core processors, and shortly there will be 8-core procesors. SQL is licensed by number of CPU sockets, not number of cores.

You need to look at your recovery SLAs when you plan your backup strategy. The main point in taking a backup is to be able to do a recovery,...

At my old place I once did a test with Litespeed on a c 300 GB DB. I don't have the exact figures, but when backing up to 1...

I tend to istall the DTS Designer components on a new build after applying any SPs and CUs. But then a new SP or CU comes along and it...

Don't be in such a hurry to write off SSAS. Can you...