Jeff, you should be able to link to it here

http://community.sageaccpac.com/forums/t/1193.aspx

I got a more conservative, informal recommendation from a former coworker who now works for Microsoft and does scalability testing for SQL Server. For 64-bit SQL Server she recommended...

OK, sorry I missed that in the comment!

My personal rule of thumb has been to never use a table variable if more than 500 rows. This posting by the SQL Server team says never use a...

Find and fix the root cause. Even if you add more RAM, who's to say it will be enough to be adequate? At some point the responsible person...

See my comments just posted on a different (but similar) thread.

http://www.sqlservercentral.com/Forums/Topic859371-360-1.aspx

I think there is confusion between DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE. If you are wanting to clear cached Execution...

First, can you give us an approximation of the workload and concurrent users? Small, moderate, large?

Second, are there a lot of Functions or Stored Procedures created for the application?...

Found it. Use this script to get a better picture of the time to compile SQL statement(s), Function(s), or SPROC(s).

use <mydatabase>

go

dbcc freeproccache

go

checkpoint

go

set statistics profile on

go

set statistics io on

go

set statistics...

Grant is correct, but the command you need to use is DBCC FREEPROCCACHE. The command mentioned by the previous poster will actually drop the cached data pages.

Please see posting...