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 37 (367 total posts) < 1 second(s)
  • SQL Saturday Chattanooga is THIS WEEK!

    My goodness how time does fly. It seems like just a few months ago I was going to my hometown SQL Saturday in Nashville, and now here I go again to my NEW hometown SQL Saturday in Chattanooga, TN. Much like the Nashville event, I didn't really do anything in terms of organization of the event, but I will be speaking at the event this year (last ...
    Posted to Louis Davidson (Weblog) by drsql on June 21, 2017
  • Father, Son, Daughter, and SQL

    I don't love Father's Day. Mostly because I spoke to my father for the last time on Father's day back in 1996. He wasn't feeling well, we exchanged a few pleasantries, and the words I remember were: &quot;I don't feel well, let me give you to your mother.&quot; Better than the actual last word's that Marshall got: &quot;that fungus thing is acting ...
    Posted to Louis Davidson (Weblog) by drsql on June 18, 2017
  • Utility to temporarily drop FOREIGN KEY constraints on a set of tables

    I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There was one central table, and 8 tables related by a FOREIGN KEY constraint. The central table had 6 million rows, and a few of the other tables 20+ million. TRUNCATE is amazingly fast,and when ...
    Posted to Louis Davidson (Weblog) by drsql on June 15, 2017
  • Utility to script a FOREIGN KEY Constraint

    Note: Amended to include the word include in the first Note (I am a terrible editor of my own writing!) and to fix a bug in the code with a misplaced parenthesis Note: Amended to include cascading and NOT FOR REPLICATION. As noted in my previous post, I am in the middle of building a utility (for work, and for my next SQLBLOG post), that ...
    Posted to Louis Davidson (Weblog) by drsql on May 24, 2017
  • Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

    I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table, but then replace them without having to save off the script manually. Part of the process is to generate the script for the foreign key constraint, so the first thing I need to do is to ...
    Posted to Louis Davidson (Weblog) by drsql on May 7, 2017
  • Speaking at the Nashville SQL Server User's Group on April 28th.

    And they say you can't go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server User's Group. (And where I moved to was very near the home I lived in when I was in high school.) The session I will be doing is a one off session of demos of some of the new T-SQL features that ...
    Posted to Louis Davidson (Weblog) by drsql on April 18, 2017
  • SQL Saturday Birmingham #593 is this weekend!

    It has been a while since I was last in Birmingham (Alabama) for a SQL Saturday. They didn't have one last year, and the event they did have was on the same weekend as Music City Code, so I wasn't able to attend. This year, I can't make it to SQL Saturday in Richmond due to this event, so I am fairly sure things have balanced themselves out. I ...
    Posted to Louis Davidson (Weblog) by drsql on March 14, 2017
  • Music City Code, a great conference that you may have never heard of yet

    For quite a few years, Nashville, and then Chattanooga had a conference called Devlink. It was low on cost, and high on education, and run by the awesome John Kellar (@johnkellar), who wrote the forward of my 2012 book. It was an amazing conference and was the place where I learned (well, in many cases learned about) a lot of stuff that existed in ...
    Posted to Louis Davidson (Weblog) by drsql on February 26, 2017
  • A new (to me, and possibly you) SSMS feature - Query Plan Comparing

    Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of SSMS (okay, perhaps not &quot;recent&quot;, more like this October of 2015, according to this blog by the MSSQL Tiger Team:), they added the ability to compare query plans. I tried it on a ...
    Posted to Louis Davidson (Weblog) by drsql on January 26, 2017
  • Saving a Few Lines of Code by Performing Multiple Operations in a Single Command

    I was in Mike Byrd's session on in-memory technologies the other day and I saw him do something I had never seen and it prompted me to write this blog today. It has nothing to do with in-memory, as the title notes, but has to do with stacking commands in a statement I had not seen before. This was SET STATISTICS. For my entire career, I have put ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement