Incremental statistics … How to Update Statistics on 100TB Database

I really like the idea of Incremental Statistics and what it can offer customers, specifically around reduced maintenance times and I’ve been trying to find a real life example of how a customer has used this feature to help them manage super huge databases. I was fortunate enough that one of our Brazilian colleagues has…

5

SSMS March 2016 Now Doesn’t Fail to Install

Last week I wrote here about how the March 2016 SSMS installation fails if the visual studio 2010 shell and SP1 update haven’t been installed first. Well now with the recent release of SQL Server 2016 RC2 this is no longer an issue.  Not only is it fixed but SSMS is now using the Shiny…

2

SSMS March 2016 Fails to Install

It’s super frustrating when software fails to install, it’s especially frustrating when the log file doesn’t give you any useful help in figuring out why!   I’ve just set up a new VM with SQL Server 2016 RC1 and now need to install SSMS on the same machine.  My Hyper V VM is an offline…

3

Restoring the master database, but not in this way!

When working on issues, we do a whole series of investigation steps, these tend to lead to other random checks which are performed that can often lead to other interesting things. Whilst working on an issue relating to permissions with a customer I asked for the output of DBCC DBINFO on the master database.  This…

0

AlwaysOn Secondary with Out-Of-Memory Errors…

Environment Three node Availability Group set, with two asynchronous secondaries. Windows Server 2012 R2, with SQL Server 2014 RTM across all nodes. One of the secondaries is in read-only mode and carries an additional workload for reporting and analysis. Problem: One of the asynchronous secondaries suffers an Out of Memory (OOM) condition and restarts. Investigations…


SQL 2012 Latest Update Confusion

The latest release of SQL 2012 updates has risen a little bit of confusion, especially around why have we released SP3 CU1 before SP2 CU10 meaning SP3 CU1 doesn’t contain all the previous fixes (SP2 CU10s fixes). The short answer to this is that each service pack creates a baseline for customers and has its…

0

SQL 2016 Load Balanced Readable Secondary Replicas

Continuing the theme of new features in SQL 2016, today I’ll introduce read workload load balancing with AlwaysOn Availability Groups. What is a readable secondary? A secondary replica can allow read-only access to all its secondary databases in the form of user connections or application connections.  Even though we class this as “read only” the…

3

SQL Server 2016 DTC Support In Availability Groups

In this post I’ll discuss the new support for Distributed Transactions in SQL Server 2016, how this is made possible and show a brief example of a distributed transaction from TSQL and a simple COM Application against a database in an Availability Group and a stand alone database. What is MSDTC? The Microsoft Distributed Transaction…

4

SQL Server 2012 Cumulative Updates

SQL Server 2012 has just had 2 new CUs released, if you are still running on SQL Server 2012 SP2 then there is CU10, if you are on SQL Server 2012 SP3 then it’s CU1 and in a departure from the previous process of needing to register to download the CU installer they are free…