Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark

(EN)In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.

(DE) In...

Availability Group on SQL Server 2016

The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...

Changing what SSMS opens on startup

When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...

Columnstore Indexes – part 97 (“Working with Strings”)

Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...

Improve performance by replacing temp tables with memory optimized tables - Part 1

There are many cases where you will be using temp tables, and many of us are trying to seek for...

My backup and SLEEP_BPOOL_FLUSH

I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...

Running SSMS 2016 in Read Uncommitted Mode

Back in July when we received the first official release of SSMS not tied to an engine release we got...

SCOPE_IDENTITY() or @@IDENTITY

I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...

Speaking at SQL Konferenz 2017

I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt...

SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.   Charted data looks like in...