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.
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...
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...