Hi Gail,

 I ran this code (with thanks to P. Randal for an explanation as to what DBCC PAGE did [1]). The results from the DBCC PAGE are attached...

Hi Gail,
In answer to your question, neither 'read_committed_snapshot' nor 'allow_snapshot_isolation' are enabled. It is at 'Read Committed'.
I haven't gotten around to looking at Ben's queries yet.
Thanks very...

We upgrade whenever the support expires, namely every 7-8 years. There are rarely enough new features that are so good that we can make a business case to initiate an...

We upgraded to SQL Server 2016 in the springtime from SQL Server 2008 and the first difference that jumped out at me was the time taken for backups. What had...

We have our code reviewed within the team and it is amazing how often little mitsakes (ahem) get through. When that is not an option, I leave it until the...

The rubber-bands brought back memories.
In one of my more enlightened companies with whom I've worked in the past, we were allowed to play network games in the office after...

My understanding of a team is the following:
 1. It is a group of people working towards a common goal. It is a unit.
 2. Despite the differences in ability and...

I have two points:

 1. I wish that developers (at least, our developers anyway) would regard the DB as something less than a place to dump data and as...

First of all, I agree with Grant. Internet-facing machines need to be treated with a level of paranoia. They must be patched as soon as possible and only kept online...

If the developers want to introduce the likes of MongoDB, someone will have to support and maintain it. We don't know MongoDB, but I would happy to put time...