Temporal extensions to SQL Server

Question

Anyone know of any temporal (http://en.wikipedia.org/wiki/Temporal_database) extensions to SQL Server?

Janycejanyte

connect.microsoft.com/SQLServer/feedback/details/557002/… – Thurnau

Sure wish there was some traction on this! Looks like MS is still sitting on their hands letting IBM DB2 and Oracle race to the front with these features. :-/ connect.microsoft.com/SQLServer/feedback/details/816474/… – Life

I feel like you could get something interesting working with CLR user-defined types, although performance would be a challenge. If I'm sufficiently motivated, and you're still interested I'll knock something up and github it. – Fulgurating

Answer 1

I know this is an old question, but the usual solution in SQL Server is to create a "Date Dimension" database that you can join in your query. A DateDim is basically just a list of dates, but it includes columns like fiscal quarter and calendar quarter number, first/last day of that month, etc.: stuff that's difficult or time consuming to calculate on the fly but is easy to pull from a joined table.

If you search "sql date dimension" you'll find some code that will generate the table for you, though you'll need to tweak it to fit your needs. They tend to run day-by-day, but if you need hourly tracking you'll need to alter the code accordingly, for example.

Hattiehatton

Answer 2

SQL Server 2016 introduced Temporal Database capabilities.

See:

• The MSDN Documentation
• This Channel 9 Video
• The public preview (CTP2) announcment

Hypoderma