I've used the method to set your DB in "bulk logged" recovery mode before the index rebuild and then set it back to "full" after.

This does not break...

The only way I know to directly read a trace file is to open it in SQL Profiler. You can also load the trace file into a table (which...

SELECT * FROM :: fn_trace_getinfo(default)

displays ALL traces running

sp_trace_setstatus @traceid=1, @status=20=stop,1=start,2=stop/purge

ie.

exec sp_trace_setstatus 1, 1

We use two jobs for each databases tran log backups. One runs once a day and does the init. The other runs every hour.

Nice catch Manu, thanks for correcting me. I was under the impression that the log chain is still good in Bulk Logged mode and during a restore you...

I think a log shipping solution may be a little faster. Yes, the users will be knocked off when you restore the tran log (same as snapshot replication) but...

Switching to Bulk-logged and back to full again will not affect your log chain. Your Point In Time recovery using tran log backups is still in tact.

use DBCC MEMORYSTATUS

Add a step before to change the recovery model to Bulk-logged.

ALTER DATABASE [dbname] SET RECOVERY BULK_LOGGED

then, add another step at the end to set it back to full recovery (if...

Idera has a free tool called SQL Permissions.

Don't foget that a passive mirror does not have to be licensed. However, when you Snapshot it, a SQL Server license is required.

Just wanted to add that the MAXDOP setting is per process. If that's what you're looking for - Great !. There's another setting that tells SQL to always...

Here's a presentation I put together many years ago when I was a DB2 DBA. It was for the summer interns each year. There's some Oracle and MS...

Thanks for clarifying Jonathan. I was trying to just keep the discussion simple on the kernel and I believe what I simply called "Stealing" is the non-technical term for...

I believe (could be wrong) at least 2-3gig (based on boot.ini) is set aside for the os in the kernel. So, you can still take full advantage of your...