SQL Server FAQ
Since functions are not pre-compiled, is there any performance gain from using user-defined functions as opposed to stored procedures?
Is it better to have one large server running multiple databases, or several smaller servers running one database each?
We have a growing population of Access users. My question is whether there is a way of lowering these user's priorities on our SQL Server?
In Performance Monitor, there is an object called Network Interface. What does it mean and under what circumstances would you use it?
We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?