Queue measures the number of things waiting. Hence it's an integer value and it's a count of...

I never said the avg disk queue length was incorrect. It's not. All perfmon counters report accurate, correct values.

The avg queue length is near-impossible to interpret on a SAN....

Ran across an interesting article while working through my rss reader

http://lifehacker.com/5486247/learning-just-in-case-versus-just-in-time

You can't decide to lean about something when you need it if you don't know it exists, but at the...

There's too much between the OS and the disks to get a meaningful threshold for queue length when there's a SAN. It's one of those counter where a value far...

That'll cause the overnight log backups to be large

Other than that, if there's a time of day where they're consistently large, consider running a server-side...

Here you go

http://support.microsoft.com/kb/324270

On Server 2003 RTM, the setting for SynAttackProtect is 0. With SP1 it was changed to 1.

iirc, that's the one that we had to change back to...

Where did you get the question from?

Transactional replication is the same. Primary key required.

I'll be blunt. You aren't likely to get anyone really good for that. I...

I'll look. This was a few years ago though...

Please run DBCC CheckCatalog on the original database (on SQL 2000).

On SQL 2000, checkDB does not run checkcatalog, hence schema corruption (as this appears to be) can go unnoticed for...

Plan caching. The first time you run the query it has to be compiled and an execution plan generated. Subsequent queries used the cached execution plan.

Is this question from the actual exam, or from study material?

If it's from the actual exam, then this is a major violation of the NDA and you should edit that...

When you're bidding for work (consulting), a collection of qualifications can make...

Robert Biddle (3/5/2010)

---

In my environment, I've noticed some very large transaction log backup files. This is not a very large database and it is not being written to a lot....