SQL Performance Management

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 …

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 …

SQL Storage Management

SQL Server Performace on Solid State Drives (SSD)

Solid State Disks (SSDs) are devices that take advantage of the high speed nature of flash memory chips to provide fast persistent data storage

sp_storage: A proc to manage disk space in SQL Server

sp_storage is a procedure that I wrote to help me manage available disk space on a SQL Server

SQL Coding Techniques

Using a UDF and Computed Column to replace a Column with a Lookup.

A reader, Rebecca, wrote asking:
I have a table that contains a column. That table and column are used throughout our web site. The column is no longer valid and needs …

Checking for Primary Keys

There are many reasons for almost every table to have a primary key.  This articles UDF locates any user tables that don’t have primary keys. Here’s the CREATE FUNCTION script:
SET …

SQL Security

“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