Differences between Delete and Truncate in SQL Server
Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.
Half Baked Features
Steve Jones notes that some features aren't fully developed, but that's not a reason to avoid releasing them.
Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level
In this article, Greg Larson reviews why a block predicate is important when you implement row level security using SQL Server 2016.
Software Maturity with Release Management
Adding a release management tool to your software development is a sign of maturity.
SQL Server RTM - June 1
The next version of SQL Server 2016 will be released on June 1, 2016, which means you can start planning those upgrades.
Implementing SQL Server In-Memory OLTP
How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .
Join Operations – Hash Match
The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.
The SQL Server 2016 Query Store: Analyzing Query Store Performance
There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers