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 23 (230 total posts)
  • 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
  • Presenting on Concurrency Three Times This Month…Though Not Concurrently

    Tomorrow night, March 15, I will be at the Hampton Roads SQL Server User Group’s March meeting, then at SQL Saturday Richmond on Saturday the 19th, then finally back at home on the 25th for my home user group in Nashville (which I haven’t seen much of this year) to present a presentation that I am pretty fond of after having done it once before in ...
    Posted to Louis Davidson (Weblog) by drsql on March 15, 2016
  • Row Level Security – Part 1–Simple Read operations

    This is part 1 of my Row Level Security blogs for my upcoming book project. Row Level Security is a very interesting feature. Unlike Dynamic Data Masking (link), which looks interesting on it's face, once you dig in the utilization of the feature looks to be limited by how granular you can make the security work. Row Level Security on the other ...
    Posted to Louis Davidson (Weblog) by drsql on February 15, 2016
  • The biggest table in your database

    You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is very useful to check the indexing strategy of these tables. There are several methods to know which is the biggest table of a database, one of these methods is to use the standard ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 11, 2016
  • Is It Ever Better to Not Name Constraints?

    This is part 1 of my Tips and Tricks blogs for my upcoming book project. For all of my professional writing career, I have been forced to be on the top of my formatting game when writing code. Uppercasing this, spacing this, aligning that, formatting code just right. In my personal life, I also try to format my code in a readable manner, though ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2016
  • Snapshot Isolation Level and Concurrent Modification Collisions - On Disk and In Memory OLTP

    This is part 1 of my In Memory OLTP blogs for my upcoming book project. In this blog I want to take a (reasonably) quick look at how concurrent modifications are handled using SNAPSHOT isolation level. There are two different flavors of SNAPSHOT Isolation level you can deal with, and while they are similar, there are some very big differences ...
    Posted to Louis Davidson (Weblog) by drsql on August 13, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement