Viewing 2 posts - 1 through 2 (of 2 total)
Instead of "Lookup Tables" we call them "Static Tables", since the content is updated relatively rarely.
In systems with big amount of tables we even putt prefix ST_ for them.
March 24, 2006 at 9:36 am
#628665
Look at SQL Server properties, memory tab.
Default settings are - "Dynamically ..." and all physical memory of server.
If awe is not enabled, sql server starts using > 2gb and high...
February 17, 2006 at 8:39 am
#621694