Talks and Seminars
In-Memory Tables with Natively Compiled T-SQL: Blazing Speed for OLTP and More December 1, 2016 in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more
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 … Read More
Natively Compiled T-SQL: The Fastest SQL Ever! September 18, 2016 Download the Presentation .Natively-Compiled-T-SQL-Andrew-Novck-presentation
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 … Read More
Writing Faster T-SQL Stored Procedures and Functions: Lessons Learned April 28, 2015 Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance.
Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014 August 31, 2014 This webinar is now available for viewing online at any time. (About 60 Minutes)
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 … Read More