Denny's SQL Secrets

@mrdenny


When Should You Create New SQL Server Indexes?

Here's how to spot when new indexes are needed to improve performance.

Exploring SQL Server's Distributed Transactions

Here's what you need to know about distributed transaction and when you should use one.

Using In-Memory OLTP Tables in SQL Server 2014

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features.

Troubleshoot Slow-Running Queries In SQL Server

Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server.

Dealing with Negative Session ID Denials in SQL Server

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error.

Redmond Tech Watch

Sign up for our newsletter.

I agree to this site's Privacy Policy.