Tag Archives: SQLNewBlogger

Basic XML Node Query–#SQLNewBlogger

Posted on June 30, 2016 by way0utwest

  Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently about querying an XML document. Certainly avoid this in the database if you … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Basic XML Node Query–#SQLNewBlogger

Getting the Previous Row Value before SQL Server 2012

Posted on June 23, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a post where someone that was trying to access the previous value in a table for … Continue reading →

Posted in Blog | Tagged , | Comments Off on Getting the Previous Row Value before SQL Server 2012

When were statistics updated?–#SQLNewBlogger

Posted on June 16, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

OBJECT_ID()–#SQLNewBlogger

Posted on June 8, 2016 by way0utwest

  One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in SQL Server. For example, I was looking at STATS_DATE recently, and it has this definition. STATS_DATE (object_id, stats_id) In … Continue reading →

Posted in Blog | Tagged , , | 2 Comments