Boost SQL Server Database Performance with In-Memory OLTP

In this article, we are presenting our new course titled “Boost SQL Server Database Performance with In-Memory OLTP” and explain how can the course help you, significantly improve the performance of your SQL Server-based data processes.   What is In-Memory OLTP in SQL Server? In-Memory OLTP, is SQL Server’s powerful In-Memory Optimization Engine, which is … Read more…

SQL Server Index Rebuild Scripts

This article provides different SQL Server index rebuild scripts. Script 1: Rebuild all indexes in a SQL Server database with specifying the Fill Factor: –Rebuild all indexes in a database –Note: You need to specify the fill factor USE [DatabaseName] GO EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 90)”; GO   Script 2: … Read more…

Locking and Blocking in SQL Server

This Article about Locking and Blocking in SQL Server is from my eBook “Tuning SQL Server (Second Edition)” Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The majority of modern relational database management systems (RDBMSs) make use of lock-based concurrency. Lock-based concurrency is the approach based on which the Database Engine of a … Read more…

In-Memory OLTP Simulator: The Experiment

A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that we developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server.   What Does the Paper Discuss? This paper presents … Read more…

In-Memory OLTP: Comparison of Features/Limitations between SQL Server 2014 and SQL Server 2016

In earlier articles I talked about the In-Memory OLTP Engine in SQL Server. Even though it is very powerful, it had some limitations (note the past tense of “have” here as I have some good news! 🙂 For example, you couldn’t use subqueries in the clauses of a SELECT statement inside a natively-compiled stored procedure, … Read more…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios.   A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…

In-Memory OLTP Simulator v1.0 Now Live!

After two years of heavy development, my tool “In-Memory OLTP Simulator” is finally out! In-Memory OLTP Simulator enables the IT Professional and Developer to easily test the powerful In-Memory OLTP Engine of SQL Server 2014® (or later) with different simulations and against different workloads. In the Ultimate Edition of the tool, among other, the user … Read more…

tempdb growth

As its names implies, the tempdb database contains temporary data that is created during SQL Server operations, therefore, the tempdb growth is one significant issue that needs to be properly managed in SQL Server. Temporary data stored in tempdb system database Temporary data stored in temdb may include: temporary user objects (i.e. temporary tables, cursors), … Read more…