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 » t-sql   (RSS)
Showing page 1 of 22 (220 total posts)
  • Utility to reset a sequence next value based on a table/sequence relationship

    So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all of my tests, everything was great. Got out Redgate Data Generator to load up a few hundred ...
    Posted to Louis Davidson (Weblog) by drsql on July 22, 2015
  • SQL Formatting Matters…

    … to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the sharpest developers have a preferred SQL ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 20, 2015
  • 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
  • Time to Start Plotting My 2016 Database Design Book

    Note: A new version has been talked about for years, but it is not a guarantee. This post is my way of introducing the new features of SQL Server, and follow on posts will be code filled example of how the features will work. I am making no promises at this time, but when I can, I will. With the recent release of a CTP version of what is called ...
    Posted to Louis Davidson (Weblog) by drsql on June 16, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 4 ("Statements that each Trigger should have")

    This is the fourth blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The previous parts can be found here:SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'')SQL Server DML Triggers - Tips & Tricks - Part 2 (''Thought to work on multiple rows'')SQL Server DML ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on May 1, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 3 ("Trigger debug")

    This is the third blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first and the second parts can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'') SQL Server DML Triggers - Tips & Tricks - Part 2 (''Thought to work on ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 21, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 2 ("Thought to work on multiple rows")

    This is the second blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first part can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'').   Triggers must be thought to work on multiple rows One of the most frequent mistake I have seen ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 5, 2015
  • New Book! T-SQL Querying with Itzik Ben-Gan, Dejan Sarka, Kevin Farlee

    I'm excited to announce that after a year of work, T-SQL Querying is now available in e-book form (dead trees will ship next month)!  As you might guess from the author list, this book goes deep into various aspects of T-SQL -- both from querying and query processing perspectives. The book includes Itzik's signature T-SQL coverage, data ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 26, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement