SQL Server FAQ
Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
In the past couple of weeks, my SQL Server seems to be running slower. Queries just don't seem to run as fast. What should I do?
Why is it better to use RAID 1 for the operating system, SQL Server binaries, and the swap file? What advantages does RAID 1 have over RAID 5?
My question is how do I move already existing log files in a different drive, or how can I separate data files and log files into different drives?
We have five SQL servers running on different physical servers. What are the downfalls for combining these SQL servers onto a single physical server?