Talks and Seminars
The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed. What you can accomplish is astounding. This presentation will introduce you to the Hekaton technology and show how big the differences can be and where you can put it to best use starting …
Natively Compiled T-SQL: The Fastest SQL Ever! September 18, 2016
Demo files: Natively-Compiled-T-SQL-Andrew-Novck-demo-sql
SQL Server’s In-Memory tables are accompanied by Natively Compiled Stored Procedures and Functions that run at amazing speed. However, the speed boost comes with tradeoffs.
The complete T-SQL language is not implemented, only key parts and we’ll discuss these limitations and how to get around some of them.
Transaction handling is different …
Some of the concepts we will cover include:
Ways to find code that’s slow:
DMV’s like sys.dm_exec_procedure
SQL Profiler and Server Traces
Writing your own logging code. (My favorite but it’s a lot of work)
Why scalar and TVF functions are slow
Finding high use functions with …