I'm curious about this, too, but nobody has really answered the original poster's question about whether or not it's normal for PLE to drop during an index rebuild.

My guess would...

It is a DBA only function, but we already have CLR enabled, and we already use managed code for other DBA functions. When we create our utility database on a...

I want to pass in a top-level backup directory path and have the procedure list all files found in all subdirectories. The idea is to build a list of backup...

Jonathan,

This function is exactly what I was looking for as part of a SQL Server Disaster Recovery solution I'm developing. The only additional thing I would need to do would...

We're considering using mount points with our SQL clusters as well, but with a twist. We'd like to be able to add mount points on a per-database basis, creating new...

I'm seeing this error in SQL Server 2005 - 9.00.3161.00 (X64), as well, when attempting to create an FSO object. I haven't opened a ticket with MS yet. I'm going...