URGENT: configure/optimize SQL Server w/read-only data
we have about 200MB of data in our database that is only used for reporting (it isn't updated). we would like to configure SQL Server to take advantage of that. since it's so small i imagine that SQL Server could read all of the tables into memory and never go back to disk and never worry about locking
anyone know how to configure SQL Server to do this?