So I found out the not too hard way. I am recommending that DB servers are set up as RAID 10 from now on. Our sysadmin hadn't seen such a...

I appreciate the opinion, but the machine has mostly been built to a spec my company uses, and proves quite sufficient for the workload we have on it. I had...

Both versions are SQL Server 2014 Standard.

I have been using SQL Compare to deploy the database changes to production, so they are the same schemas.

We have installed a smaller set of 146 GB 15K drives in...

Hi Jeff,

I haven't done anything with statistics yet.

I have set the server up to let SQL Server use up to 90% of the memory.

I haven't checked the anti-virus settings yet.

I...

Hi Kevin,

Thanks for the ideas. I am going to try some of these out when I get the server back on-line. I have also created a second data RAID with...