Drop a temporal table

Question

Drop a temporal table

Koen Verbeeck

SSC Guru

Points: 259115
More actions
July 16, 2015 at 12:20 am

#305878

Comments posted to this topic are about the item Drop a temporal table
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2015 at 4:07 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 28 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Hmmm, people have actually selected "drop the database". :w00t:

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

Carlo Romagnano SSC-Insane Points: 22679 More actions · Answer 2

I read about TEMPORAL TABLE just two weeks ago.

Good qotd!

🙂

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Shameless plug: after posting this QotD, I took the time to write a blog post about it:

How to drop a temporal table[/url].

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

Carlo Romagnano (7/16/2015)
I read about TEMPORAL TABLE just two weeks ago.
Good qotd!
🙂

We like to stay on edge here at SSC 😀

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

Richard Warr SSCertifiable Points: 6967 More actions · Answer 5

Koen Verbeeck (7/16/2015)
Hmmm, people have actually selected "drop the database". :w00t:

That would certainly achieve the stated goal.

Plus some other ones.......

Heals SSCrazy Points: 2234 More actions · Answer 6

Koen Verbeeck (7/16/2015)
Shameless plug: after posting this QotD, I took the time to write a blog post about it:
How to drop a temporal table[/url].

Hehe - that's what I read up on to find the answer to the question 🙂 The comment about the SSMS scripting was handy too.

Glad I checked back as I was about to post a link to it myself (Been one of those mornings - I didn't realise it was one of yours!).

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

Heals (7/16/2015)
Koen Verbeeck (7/16/2015)
Shameless plug: after posting this QotD, I took the time to write a blog post about it:
How to drop a temporal table[/url].
Hehe - that's what I read up on to find the answer to the question 🙂 The comment about the SSMS scripting was handy too.
Glad I checked back as I was about to post a link to it myself (Been one of those mornings - I didn't realise it was one of yours!).

Ha, I should've waited to post that blog after this question was published 😀

Now it's all too easy 😉

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Richard Warr (7/16/2015)
Koen Verbeeck (7/16/2015)
Hmmm, people have actually selected "drop the database". :w00t:
That would certainly achieve the stated goal.
Plus some other ones.......

If the goal is to leave the company as soon as possible 🙂

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 9

Koen Verbeeck (7/16/2015)
Richard Warr (7/16/2015)
Koen Verbeeck (7/16/2015)
Hmmm, people have actually selected "drop the database". :w00t:
That would certainly achieve the stated goal.
Plus some other ones.......
If the goal is to leave the company as soon as possible 🙂

If the company stores data it cannot afford to lose in a CTP, then leaving the company would definitely be my goal. 🙂

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Umer Akram SSC-Insane Points: 22209 More actions · Answer 10

nice question. Thanks for sharing Koen

nice to see your name in posted by 🙂

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

Nice question, Koen. I've read some stuff about temporal tables, but that's about it.

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 12

Is this where you write "Thanks for the question"? 😀

Thanks for the question :hehe:

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Junior Galvão - MVP SSCertifiable Points: 6951 More actions · Answer 13

Hi,

Good question!

This post helped me in reply

http://sqlwithmanoj.com/2015/06/15/temporal-data-support-in-sql-server-2016-part-1/