There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or ...

Capacity planning, especially when done for SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL ...

How much server memory is enough, and for how long? Brien works through the math as part of his ongoing hardware refresh. I have been giving a lot of thought recently to the subject of system capacity ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

i have a project that differs from previous architectures sufficiently that i'm hoping input from this board might be useful.<BR><BR>i know how to generate capacity planning equations for web servers ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...