Adding Temporal Support

Question

Adding Temporal Support

Steve Jones - SSC Editor

SSC Guru

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

#100941

Comments posted to this topic are about the item Adding Temporal Support
October 30, 2016 at 11:13 pm

This was removed by the editor as SPAM

Viewing 9 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: 33109 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: 259115 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