THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Temporal Data   (RSS)
  • Temporal Tables - Part 5 - Start and End Type Precision

    In this fifth (and maybe final until at least getting to the concurrency chapter prep) blog about temporal I wanted to briefly cover the precision of the ROW START and END times. You can use any of the datetime2 types for these values. The precision will let you choose how many changes would be seen by the user. Even with 6 digits of precision ...
    Posted to Louis Davidson (Weblog) by drsql on May 21, 2016
  • Temporal Tables - Part 4 - Synchronizing changes across tables

    So way back in June of last year, when I started this series on Temporal Tables: Part 1 - Simple Single Table Example, Part 2 – Changing history; and even in Part 3 - Synchronizing Multiple Modifications; I only referenced one table. In this entry, I want to get down to what will actually be a common concern. I want my objects to be consistent, ...
    Posted to Louis Davidson (Weblog) by drsql on May 9, 2016
  • Temporal Tables - Part 3 - Syncing Multiple Modifications

    Back last June, I started this series on temporal tables, and in my head, I had enough information to make an educated set of examples on how to use them. In the back of my mind though, I knew that I hadn't quite thought enough about the whole process, particularly when you have several rows (or as I will note in the next blog entry, tables) that ...
    Posted to Louis Davidson (Weblog) by drsql on May 2, 2016
  • Temporal Tables – Part 2 – Changing history

    After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a question that piqued my interest. How might you edit history? Well, the answer is simple, but the process isn’t exactly simple. Basically, you have to turn off system versioning, update history, and reapply system versioning. Not difficult, ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2015
  • Temporal Tables – Part 1 - Simple Single Table Example

    In my first entry in my series of posts on DB Design Book Topics, I want to start with a pretty interesting topic, Temporal Tables. It is a very cool new feature that takes something that used to be very painful (capturing history of changes to a table, allowing the user to see the data at a point in time), and makes it very easy. So if you have ...
    Posted to Louis Davidson (Weblog) by drsql on June 29, 2015
  • Working with Temporal Data in SQL Server

    My third Pluralsight course, Working with Temporal Data in SQL Server, is published. I am really proud on the second part of the course, where I discuss optimization of temporal queries. This was a nearly impossible task for decades. First solutions appeared only lately. I present all together six solutions (and one more that is not a solution), ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on May 29, 2014
  • SQL Rally Pre-Con: Data Warehouse Modeling – Making the Right Choices

    As you may have already learned from my old post or Adam’s or Kalen’s posts, there will be two SQL Rally in North Europe. In the Stockholm SQL Rally, with my friend Thomas Kejser, I’ll be delivering a pre-con on Data Warehouse Modeling: Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to ...
    Posted to Davide Mauri (Weblog) by manowar on October 9, 2013
  • SQL Bits X – Temporal Snapshot Fact Table Session Slide & Demos

    Already 10 days has passed since SQL Bits X in London. I really enjoyed it! Those kind of events are great not only for the content but also to meet friends that – due to distance – is not possible to meet every day. Friends from PASS, SQL CAT, Microsoft, MVP and so on all in one place, drinking beers, whisky and having fun. A perfect mixture for ...
    Posted to Davide Mauri (Weblog) by manowar on April 11, 2012
  • PASS Summit 2011 – Slides & Demos

    Just reading from all posts and tweets it’s quite clear that this year’s PASS has been a great success. Despite of the bad cold that I had from Monday , I’ve enjoyed it at lot. All the parties, the friends, the community and the great content make PASS an appointment one that should not to be missed. I’ve also enjoyed a lot delivering “Temporal ...
    Posted to Davide Mauri (Weblog) by manowar on October 18, 2011
  Privacy Statement