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 24 (235 total posts)
  • Quick Regions in SQL Server Management Studio (SSMS)

    There are a few tools and add-ins that support the creation of “regions” in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate sections of long-ish T-SQL scripts natively, by using begin/end: To demonstrate, start with a snippet of T-SQL that includes begin/end: If you click on the “-“ highlighted above, the code will ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 14, 2017
  • SQL Server 2016 Developer’s Guide

    I can proudly announce that it is already possible to preorder the SQL Server 2016 Developer’s Guide book (https://www.amazon.com/SQL-Server-2016-Developers-Guide-ebook/dp/B01MS5L01Q/ref=sr_1_20?ie=UTF8&qid=1488533994&sr=8-20&keywords=SQL+Server+2016). This is the 14th book I authored or coauthored This time, my coauthors are Miloš ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 3, 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 "recent", 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
  • T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

    I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it is. This changes today because I read a blog on Adam Machanic's (@adammachanic) blog that outlined the rules (here) and I have been keen to get back to blogging regularly. When I saw what ...
    Posted to Louis Davidson (Weblog) by drsql on January 10, 2017
  • 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
  • Temporal Tables

    I have delivered a talk about “SQL Server 2016 Temporal Tables” for the Pacific Northwest SQL Server User Group at the beginning of October . Slides are available on SlideShare here: http://www.slideshare.net/davidemauri/sql-server-2016-temporal-tables and the demo source code is — of course — available on ...
    Posted to Davide Mauri (Weblog) by manowar on October 29, 2016
  • The DIY guide for local-global aggregation

    If you have read the title, you will not be surprised when I tell you that this blog is about a thing called “local-global aggregation”, and on how to do that yourself. So let’s start with the two obvious questions: what the heck is local-global aggregation anyway, and why the heck would you ever want to do it yourself?   What is ...
  • How TOP wrecks performance (part 2)

    In my previous post, I showed how the vanilla version of TOP can really help performance by nudging the optimizer into picking an execution plan that is optimized for returning just a few rows instead of the entire result set. But I also showed that adding WITH TIES causes a cardinality misestimate, which may lead to suboptimal or downright ...
  • Row Level Security-Part 3-A few more advanced scenarios

    In this final entry (for now!) in my series on Row Level Security (Part 1, Part 2) I am going to show a couple of slightly more complex scenarios. I will only scratch the surface of what you could do, but keep in mind that performance is really important to how you make use of Row Level Security. In a future blog, I will build a couple of ...
    Posted to Louis Davidson (Weblog) by drsql on April 6, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement