Editing SQL Server Best Practices
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 7: | Line 7: | ||
* Always provide maximum RAM memory that you can provide | * Always provide maximum RAM memory that you can provide | ||
** Ram memory tends to be inexpensive and always best to have plenty of memory for SQL | ** Ram memory tends to be inexpensive and always best to have plenty of memory for SQL | ||
| − | |||
* More even more performance the following will give good cost performance benefits: | * More even more performance the following will give good cost performance benefits: | ||
** Use SSD or fast drives if you need ultimate performance and speed | ** Use SSD or fast drives if you need ultimate performance and speed | ||
** Have a third drive for the temp table databases. this could be SSD also for fast performance. | ** Have a third drive for the temp table databases. this could be SSD also for fast performance. | ||