SQL Performance Tips

Comparing the Performance of Rot13 Implementations

The previous two articles have been devoted to implementations of the Rot13 cipher. This is a character substitution cipher that is used to obscure text strings in the Window registry and in many web cookies. Both implementations were contributed by Luke Schollmeyer. …

read more

100 Times Faster: Experiences Making SQL Server Fly

Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12 How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables…

read more

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

read more

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…

read more

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

read more

Retrieving a Random Record in SQL Server using udf_Num_RanInt

This UDFs week solves a problem posed to me last week by a friend Gary.  Gary wants to select a random row from one of his tables and was hoping that SQL Server would have some support for this task. The idea of selecting a random row runs counter to the ideas that…

read more

“Software performance was our single biggest problem. We did everything we could do in-house to get the database running like it should and really needed some help. You quickly pinpointed problem areas and your setup, index and query recommendations greatly improved the software’s performance.”
Daniel J. Mc Intyre, Vice President
Management Computer Services, Inc.

Upcoming Events

> See All Events