Your welcome Jeff

David Naples (3/28/2008)

---

As far as the restore time difference between LiteSpeed and native SQL? I haven't actually benchmarked it, but I suspect that, since the resulting database is the same...

Good point, but what about restore time?

I have used LiteSpeed, but i'm sure there are other third party applications that gives the same result as LiteSpeed. It will reduce the size of the backups and the...

Here are some links:

http://msdn2.microsoft.com/en-us/library/ms144260.aspx

http://msdn2.microsoft.com/en-us/library/ms190920.aspx

Good luck!

Thank you for the information Gila.

Could you be more specific?

Did you solve your problem?

Could you be more specific?

Maybe you could make a SSIS package with a for each loop.

Do you have only one HDD? If you have more HDD you could try creating more filegroups.

I agree with Mohan, it should work.

GilaMonster (3/27/2008)

---

Regarding your slow downs...

You may also want to run perfmon during one of these slow downs, see if any counters are wildly different from normal.

Check pages/sec, disk...

I agree with Brian. I used LiteSpeed and with this tool you can encrypt up to 256 bit. I guess you will be able to do the same with other...

I use a script that starts rebuilding indexes in a period of an hour and a table that keeps track of which indexes has been rebuild. The job is executed...