>>If are not procedures and functions in DB and server has more memory, you can propose experiment - change from normal tables to tables in memory (in another instance).
>
>Can you elaborate more on this?
I did mean Hekaton but...
- in message header is MS SQL server 2014
- you wrote "MS SQL Server 2012" in another message
If you have MSSQL 2012, you have not more choices
- SSD disk (another message)
- One disk for data, second disc for indexes, third disc for log, forth disc for temp db
MartinaJ