I knew there had to be a more efficient way, that's very neat Adi!

You can use the BACKUP LOG command, you just need to find a way to give the file a unique name. The first thing that comes to mind is a...

Hi There,

It won't be a problem as long as the drive shows up as a local disk, and has a drive letter assigned to it. I've done it before without...

Hi Dave,

Like many other counters, the ones you listed don't have absolute good/bad values. There are many variables when it comes to determining fillfactors. Hopefully the following article will prove...

If you're not using the express edition of sql server, you can schedule a job that runs with the SQL Server Agent. Please see the following books online link for...

Dave,

When identifying memory as a bottleneck, I'd first want to confirm that memory pressure is occurring within the SQL Server engine. Memory pressure is when SQL Server needs to contend...