How Hekaton (XTP) achieves Durability for “Memory Optimised” Tables

“Memory Optimised” tables reside entirely in memory, the operations INSERT, UPDATE and DELETE as well as SELECT are all significantly quicker, but just how is it possible to achieve durability with memory optimised tables while still achieving the significantly higher throughput? Like traditional on-storage tables durability is achieved once the data has been written and hardened off(…)

Changing In-Memory Table definition without down time

One of the restrictions of a “memory optimised” table is that you cannot modify its definition once created. You may find that once your table has been in use for a period of time it may be apparent you don’t need one of the Hash indexes for example, or perhaps you made a hash (pardon the(…)

SQL Server bitmap operators, bitmasks and bit arrays

In this post I cover what bitmap and bitmasks are, before I can do that I need to make sure you are up-to speed on binary, base 2 and how the bits are layed out in data. Binary Binary (Base 2) is used throughout computer systems, the Windows platform amongst others relies on it. Base(…)

SQLBits Session “T4 Templating within SSDT using SQL Server 2014″

Very pleased that my session on “T4 Templating within SSDT using SQL Server 2014″ has been excepted for SQLBits 12.   SQL 2014 and the latest SQL Server Data Tools has made T4 much easier to use in SQL Development Projects. I gave a talk last month on ETL Design for Warehouse loads to the London SQL User Group.  The(…)

Reasons why your plans suck : No 56,536

I have been working with SQL server for more years than I really care to mention and like to think that I am now quite comfortable with the internals, specifically the Query Optimizer. Every so often though a new problem gets thrown into the mix, just to keep me on my toes ( or so(…)

Maximum IOPS for a 10K or 15K SAS Hard Disk Drive is not 170!

At times, mmm quite often now actually (perhaps it’s because I’m getting older and more grumpy) the industry I’m part of really makes me embarrassed, all too often folk just quote things they’ve seen on Wikipedia or via word of mouth without even a basic knowledge of the “fact” they are quoting – a “fact”(…)

T4 Support in SSDT

Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me.  On tuesday night, at SQL Supper, Geoff Clark ( a uk MCM ) (t) done a fantastic presentation on end-to-end datawarehouse loading, a portion of this was on t4 templating.  The question arose about SSDT and T4 templating(…)

Whats This Command Bar ?

One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out exactly what the names of the Command Bar objects internal to Visual Studio were. Most of the advice on the internet is fairly haphazard ie guess/trial and error, but there is a simpler way. Here http://1drv.ms/1fsR3n3 is(…)

SSDT – Cut n Paste substituting CMDVARs

Another thing that slows me down with SSDT is testing stored procedure that use CMDVARS. Consider this proc : If I wish to test that in SSMS, I can cut-n-paste it in then use SQLCMD mode and add in :setvar statements or simply replace the $(CmdSwitch) and $(Otherdb) with the appropriate values.  Ok for one(…)

SSDT – Fast deploy

Let me state first of that I do really like SSDT, integration of a source control system of your choice and all its extra features make its use a real boon. However…….. On my past few assignments SSDT has been heavily used, and deployment is done via Build/Deploy powershell scripts.  This is all very well(…)