Posts written by andrew novick

SQL Server In-Memory Tables

SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015 SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them.  In-Memory tables bring incredible speed for the right workload so long as a series of… Continue reading

SQL Server 2014 In-Memory Database (Hekaton)

Join me as I discuss SQL Server 2014’s new In-Memory option for tables with the natively compiled stored procedures. This features allows up to 25 times the performance of traditional disk based tables for OLTP workloads. Presentation at the New England Microsoft Developers SQL Server… Continue reading

Transact-SQL User Defined Functions – PDF available for free

It was written quite a while ago but if you’re starting out using functions in T-SQL, it’s still a good resource. Except for the section on system UDFs the rest of the book remains correct. There just haven’t been that many changes in how functions… 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

Scripting Traces for Performance Monitoring on SQL Server

The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor… Continue reading

The Problem with User-Defined Functions (UDF) and a Solution

Download the sample script: Problem-Scalar-UDF-and-solution-andy-novick   and a PDF of the slides: The Problem with scalar UDFs and a solution – Andy Novick Or watch the video on Youtube:   User-Defined functions (UDF) have been around SQL Server since the 2000 version. They are a great way to… Continue reading