About Dave Ballantyne

Posts by Dave Ballantyne:

TSQL Smells in SSDT – The monster lives

What seems like many many moons ago, I released a powershell script that could detect many different “TSQL Smells“. Whilst it worked, I was never very happy with the interface, it was clunky and didnt feel quite ‘right’. One of my longer term aims was to do something about that and make TSQLSmells more accessible. […]

Reading a snapshot – Are there performance implications ?

My present role is to look at the performance of a large datawarehouse load.  This is right up my alley,  and I have be playing with all manner of performance tuning fun, indexing, execution plans, filtered statistics etc, all good stuff. However,  during QA testing some of my suggestions actually made things worse.  Not a little worse, but a […]

Manchester and Leeds user groups – 16/17 Oct

Thanks to all those that turned out of Wednesday and Thursday night in Leeds and Manchester to hear my presentation on Estimation and Statistics.  The ‘lucky’ Manchester crowd also got to hear ‘Trace Flag fun’, a deep dive into optimizer internals. As promised here are the slides and scripts:   Estimation and Statistics TraceFlag Fun […]

A quickie post on debugging

I’m not a great fan of the debugging feature in management studio, It always strikes me that to get any use from it then you are iterating (looping) too much ie doing TSQL wrong.  TSQL is not a procedural programming language and the debugger would seem to be most useful if you did develop TSQL […]

Nearing Nirvana with Hekaton

Rarely does a piece of technology make a difference to a system without someone (developer, DBA, architect etc) sitting down and thinking about how to apply the technology to their problems. For me one of the big pain points in TSQL development is that arrays/in memory storage are missing. If I wish to hold some […]

How full are your Hekaton Buckets ?

Hekaton is a really interesting technology, but is a world away from the functionality that we know and love. The SQL team have done a great job of disguising this departure from us by integrating it inside the SQL Server engine but none the less is a different beast entirely. Although the ultimate aim, I […]

Hekaton CTP1 – Row order limitation

UPDATE : Good news, this post relates to CTP1 only, the 8000 row limit has been lifted in CTP2 If you have been reading about hekaton and compiled stored procedure you are probably full of aspirations to move all your data into memory and magically have your system for faster. Slow down just a minute […]

Examining Hekaton Code

In my previous post, I made reference to a Microsoft Research paper on Hekaton Internals. This states that the SQL Engine produces C code which is then compiled to a DLL. So that would leave you to the assumption that there is a C file somewhere that can be looked at to find out some […]

First steps into Hekaton – XE Slow parameter passing

If you are anything like me then you will have already downloaded and installed the CTP1 release of SQL Server 2014. There are a lot of things of interest here, probably top of most peoples list is Hekaton, the new in memory OLTP transactionally compliant database. There are some bold claims with hekaton but to […]

SQLRelay – Cardiff and London – Estimation and Statistics

The basis of query optimization is Estimation and Statistics.  Without a decent estimation of the amount of rows to be processed, then the entire query plan could well be ‘wrong’.  These estimations are built via the statistics and the interactions between them is vital piece of understanding. With this in mind its always a great […]