Gregory Larsen

In one of my prior articles on In-Memory OLTP tables we talked about the different types of indexes supported by In-Memory OLTP tables: HASH and RANGE.  In that article I discuss the advantages and disadvantages of each of these different index types.  In this article I will be exploring the BUCKET_COUNT setting of a HASH […]

In my last few articles I’ve been discussing the new SQL Server 2014 In-Memory OLTP tables.  With this new in-memory feature, stored procedures can be now be natively compiled.  In this article I will be discussing natively compiled stored procedures and showing you an example where they can improve performance. What are Natively Compiled Stored […]

In my last few articles I have been exploring the new In-Memory OLTP table option that came out with SQL Server 2014.  In this article I will be exploring a new tool that also came out with SQL Server 2014 named “Memory Optimization Advisor”.  This tool is meant to help people quickly analyze their tables […]

On November 4th, Microsoft released a new set of samples targeted at In-Memory OTLP tables in SQL Server 2014.   In this article I will be exploring and explaining using these new samples.  If you haven’t yet looked into the new In-Memory OLTP feature in SQL Server 2014 CTP2 then possibly you should consider downloading SQL […]

In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility.  AMR stands for Analyze, Migrate, and Report.  In this article I will be exploring how to use this tool. What is the […]

In my article last month I introduced you to In-Memory table or what Microsoft refers to as In-Memory OLTP, or Hekaton.  This new type of table is available with SQL Server 2014.  In that article I demonstrated the basics of creating an In-Memory table.  In this article I will discuss the different types of indexes […]

There are a number of new features that became available with SQL Server 2014.  One of the more exciting features is the new Memory-Optimized tables.  In this article I will explore how to create Memory-Optimized tables, and what I’ve found during my initial exploration of using this new type of table. What is a Memory-Optimized […]

SQL Server Community Technical Preview One (CTP1) was release from Microsoft in June 2013. If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article I will walk you through preparing, downloading and the steps to install the SQL Server […]

I know you have been waiting for the next release of SQL Server.  Well you don’t have to wait any longer.  On June 25th Microsoft released the first community technical preview (CTP1) for the next version of SQL Server.  In the past, when Microsoft released new versions of SQL Server they had code names, like […]

Have you ever heard these kinds of comments before? “How come my TSQL statement is running slow today, when just last week it was running fine?” “I have a process that as I add more rows to my table it gets slower and slower?” If so then possibly your index statistics are out of date.  […]

There is a system extended store procedure called “xp_cmdshell” that can be used to issue shell commands using TSQL code.  Being able to do this can be quite useful for a number of different situations.  But when SQL Server is first installed out of the box this extended stored procedure is not enabled.  Additionally once […]

When building applications that need to display lots of data to a customer, a common practice is to display one page of data at a time.  Having your application only show a single page of data requires you to build a paging function, like a button into your application to allow the users see the […]