Running 2 x Windows 2003 x64 Enterprise in a failover cluster. 24gb RAM each<BR>SQL 2005 x64 SP2<BR><BR>My SQL instance is running at about 17gb of pagefile usage. Instance memory ceiling is set at ...

It's time to replace a SQL server, the lease is up soon. The databases are around 3-4 GB currently, just barely fitting in RAM on the current server. If I am planning on getting a server with plenty ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...