Overall, I agree with your recommendation, for production databases. I do have a scenario where I use autclose, for development workstations.

We often run SQL Server on our...

I was with a group of developers several years ago, that determined through some sort of testing that when SQL Server recovers from a catastrophic or abnormal shutdown, it bumps...

Consider using a vbs script with SQLDMO objects. Create a loop for each file, to import the file to a temp table, then run an insert query to load...

Josep;

Had the same problem, upgrading a NT4/SQL7 server from 128mb to 384mb. Found that when I increased the memory, the page file increase and became very fragmented. Now...