Category: Talks and Seminars

In-Memory Tables with Natively Compiled T-SQL: Blazing Speed for OLTP and More

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… Continue reading

Natively Compiled T-SQL: The Fastest SQL Ever!

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… Continue reading

Writing Faster T-SQL Stored Procedures and Functions: Lessons Learned

Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance. Continue reading

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014

This webinar is now available for viewing online at any time. (About 60 Minutes) http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/ 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 Extended Events Writing your own logging code. (My… Continue reading