One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Tue, Jan 29 2008
Filed under: Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager