The rebuild operation is logged. Bulk mode deals with bulk loading, it doesn't stop logging.

Use QA to generate the statement, but you'll still need to long query.

I think one has a few more options, but they work the same.

Eddie is correct. Every CPU in the system must be licensed, regardless of what's used.

The exception would be if you ran a VM on a 4 way system and had...

Depends on what you want to do. Lots of tools out there.

I'll add a note that sqlSentry has a few great tools.

Or maybe Google yourself and look for inappropriate things others have posted. It might make sense to be aware of them and have a reasonable explanation to give to potential...

Adam,

Fair points, but I didn't intend a political debate. More a concern over crossing the border because of my technical equipment being lost. To me it's no different than an...

This was a great debate, and I guess still is.

Dex, well put and that's what I'd tend to agree with. Even if you don't have a DBA, learn to write...

That is cool! nice Pix. Most data centers I've had that much equipment in had about 1/10th of the space.

I also heard that the new MS data center in...

You can't do this because applications don't need to register a port. Lots of them ask for a port when they start, and if it's not available, they ask for...

First you want to post in the appropriate forum. This has been moved to the replication forum.

Next you need to be sure that you understand replication. This isn't something that...

We have one here: http://www.sqlservercentral.com/articles/Administration/2960/

SQL Server releases a Cumulative Update every other month and we usually announce it here when they do. Service Packs are supposed to come one a...

Which events are you capturing? There are lots of events, down to the statement level, that you can capture. You can modify any trace to include the events.

Profiler allows you...

either of those tools can help.

One other thing to be aware of is documentation. You may not deploy all changes, so even with a third party tool, you want to...

Call Microsoft PSS and your hardware vendor. Almost all DBCC errors are hardware related and if you really need this data, work with Microsoft support to get it back.