top of page

Using new features

  • Adam Thurgar
  • Dec 8, 2017
  • 1 min read

In August I blogged about using the new SQL Server 2016 temporal tables for a client requirement. It did everything they required and more. The time machine worked great. But the I started questioning the client requirements and what where thinking of delivering. This is an organisation with developers, but no full time trained DBA. A few accidental DBA's. Who could or would be able to understand temporal tables moving forward? Would it just be forgotten until one day it broke. Sometimes you need to think about who is going to maintain this environment into the future. After discussions with the team we decided that temporal tables were, in this case, overkill. We went with a more basic, simple solution (using the KISS principle) and better/easier for the client.


 
 
 

Recent Posts

See All
Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

 
 
 
Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

 
 
 
Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...

 
 
 

Comments


bottom of page