it all depends on your workload....if you use tempdb a lot then splitting that is advisable. however, if your database is ready-heavy i would avoid putting indexes alongside tlog and...

max server memory is the limit for the buffer cache memory allocation. there are other areas of memory usage outside of this allocation, such as clr, which can exhaust the...

ok thank you - was hoping to use simple partitioning on 2012 ent and restore to 2016 std....will add the partitioning to test db and see what it looks like...