Query Performance TuningCommented on: 2 years ago
(June 1, 2012)
Thanks for reminding me about compression. We just upgraded one of our main production instances to 2008 and we'll take a look at it.
The Great SQL Server Migration QuestionCommented on: 3 years ago
(February 18, 2011)
We deployed SS 2008 R2 mainly because we are setting up a Sharepoint 2010 environment and we thiught that we might use PowerPivot. I also deployed it to a monitoring server because I could. As manu...
When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More