THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 35 (349 total posts) < 1 second(s)
  • Curious - How does STRING_SPLIT (2016) handle empty/NULL Input?

    If you haven't seen STRING_SPLIT, it is pretty awesome, and something we have all been working with for many years, which you can read about in Erland Sommarskog's great article here along with many other concepts involved in sending in a set of data to a stored procedure. As a quick starting example, consider the string of characters: A,B,C;D. ...
    Posted to Louis Davidson (Weblog) by drsql on November 22, 2016
  • Post PASS Summit Resolutions 2016

    So, I am finally back and lightly rested from the two big weeks of SQL learning this year (PASS Summit and MVP Summit) and like pretty much every year I am physically exhausted, feeling my age. So many sessions, so many miles put on my feet. But my brain recovers from the ordeal faster than my feet, and is like: &quot;wow, I am going to need more ...
    Posted to Louis Davidson (Weblog) by drsql on November 17, 2016
  • After PASS Summit 2016 Recap (As seen by me!)

    In my last blog entry, I promised to blog about the PASS Summit each night when I got back to the room. This was a failure for two reasons. 1. I was always out at night and then exhausted. 2. I forgot the keyboard to my Surface Pro. I tweeted about it, and was picked on by the @surface twitter account: But I did tweet about the event rather ...
    Posted to Louis Davidson (Weblog) by drsql on November 2, 2016
  • Post PASS Summit 2016 Resolutions - Followup

    Last year I started a new tradition for myself that will last until I specifically retire from the SQL Server community, something that I practically promise isn't coming in next year's resolutions. As this is the end of the PASS year, with the Summit coming up next week, it is time to see how I did with regards to what I said I would do. I didn't ...
    Posted to Louis Davidson (Weblog) by drsql on October 20, 2016
  • Where have I been? Where will I be?

    SQL Saturday Orlando has been postponed. I won't be able to make it for the make up day, so that part of this blog has changed. Not the part about me loving the folks down there. They are still awesome!&nbsp; I again have not blogged so much that I don't show up in the list on SQLBlog.com, but it is about time to start blogging again. Where ...
    Posted to Louis Davidson (Weblog) by drsql on October 3, 2016
  • 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
  • Just over a week until SQL Saturday Atlanta

    I am looking forward to being both a speaker and an attendee at this year's SQL Saturday in Atlanta (it is number 521 wow). Don't know what SQL Saturday is? (I doubt that if you are reading this blog, but if so, click here quickly my friend). My topic this year is concurrency: Let Me Finish... Isolating Write Operations OLTP databases can be ...
    Posted to Louis Davidson (Weblog) by drsql on May 11, 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
  • re: sys.dm_db_index_usage_stats

    Sorry Vinith, was on a trip when your question came through... You can't really, other than capturing the values every so often (daily, hourly), and subtracting values from one capture to the next
    Posted to Louis Davidson (Weblog) by drsql on April 23, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement