Dennis's SQL Blog

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

Welcome to the last part of this series, you can find the previous post here ( and here (

Previously we...

2017-02-24 (first published: )

4,928 reads


It’s 2021, so why are you reading this?


If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds


Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs


Magic string "sp_replwritetovarbin" causes a transport-level error

By vkirushev

Does anybody know why existence of string sp_replwritetovarbin in the statement causes a transport-level...

Is the order of the columns in the NC index important

By christi1711

Hi all, I have a table where I have 3 indexes (User Table): id_user...

Alert Mechanism

By ramyours2003

I need to configure the below alerts manually for multiple servers Backup failure, disk...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers