Adding Temporal Support

Question

Adding Temporal Support

Steve Jones - SSC Editor

SSC Guru

Points: 738171
More actions
October 30, 2016 at 6:02 am

#100941

Comments posted to this topic are about the item Adding Temporal Support

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

Stewart "Arturius" Campbell (10/30/2016)
Interesting question, thanks Steve
Really need to start playing with this....

Yeah, me too. One day, anyway.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

ManicStar SSCoach Points: 17992 More actions · Answer 2

ManicStar

SSCoach

Points: 17992

October 31, 2016 at 6:54 am

#1909591

Very cool, learned something

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

I'm not familiar with this, have to do some research.

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 4

A nice new property in Sql Server 2016. Thanks!

Igor Micev,My blog: www.igormicev.com

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 5

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

DamianC SSCrazy Eights Points: 8023 More actions · Answer 6

Had to do a bit of research on this one

Useful feature will be reviewing my approach to SCDs

Thanks

- Damian

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Interesting question. Of course there should be no need to hide the columns unless the existing apps are using "*" instead of "<columnlist>".

Adding the extra columns with defaults may be very expensive, depending on the edition of SQL Server, so converting an existing table to be versioned could be painful.

Tom

Adding Temporal Support

Cookies on SQLServerCentral