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…
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. …
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.
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…