SQL Server 2014 Std BE / Access 2010 FE
Regarding the OS that SQL server resides on.... So if we are deploying an in house solution that has say 35 users on a lan and 5 remote users does it make any difference the OS that the SQL Server resides on? Does it need to be a server OS or can i use a std windows 7 / 8.1 etc as the OS?
Is it also best practice to seperate the SQL server away from the main windows server that controls the domain and stores the networked files?
Its just that we are upgrading our main file server in the next few months to a beast of a machine and im wondering if im best in either virtulising the new server or utilising the old server as a SQL server machine only?
Finally has anyone seen much performance gain from using SSD's in the PC that runs the SQL Server?