Ken Shapley (7/17/2006)
"Generally, the rule of thumb is to have as much as RAM as your data file is."
Did you come up with this rule yourself? How many databases have you worked with in your career?
This does make sense. It may not be feasible with today's technologies and current costs of buying new RAM, but will likely be reality in a few years time. The 64-bit platform was an exotic curiosity a few years back, but not any more.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]