SQLEspresso

Understanding Columnstore Indexes in SQL Server Part 2

• by Monica Rathbun

• SQLEspresso

In my last blog I explained what a columnstore index is, in this blog, we will dive into creating a clustered columnstore index and look at the performance differences...

2019-07-10

30 reads

Understanding Columnstore Indexes in SQL Server Part 1

• by Monica Rathbun

• SQLEspresso

Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...

2019-07-11 (first published: 2019-06-26)

628 reads

Comparing Execution Plans

• by Monica Rathbun

• SQLEspresso

When you run a query twice, and get dramatically different run times, your first step can be to try to identify the differences in execution plans. For many that...

2019-07-05 (first published: 2019-06-19)

730 reads

Filtered Index Basics

• by Monica Rathbun

• SQLEspresso

In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...

2019-06-10 (first published: 2019-05-22)

673 reads

DMV’s for the Beginner

• by Monica Rathbun

• SQLEspresso

I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...

2019-05-29 (first published: 2019-05-15)

1,750 reads

Join me for a PASS Summit Pre-Con

• by Monica Rathbun

• SQLEspresso

I am very excited to announce I will be delivering a pre-conference session on SQL Server Performance Tuning on November 5th at PASS Summit 2019. If you have ever...

2019-04-24

42 reads

What is Implicit Conversion?

• by Monica Rathbun

• SQLEspresso

Another quick post of simple changes you can make to your code to create more optimal execution plans. This one is on implicit conversions. An implicit conversion is when...

2019-04-29 (first published: 2019-04-17)

947 reads

What’s a Key Lookup?

• by Monica Rathbun

• SQLEspresso

One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...

2019-04-17 (first published: 2019-04-03)

661 reads

Women in Tech Talk Tech

• by Monica Rathbun

• SQLEspresso

March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...

2019-04-09 (first published: 2019-03-20)

1,002 reads

Enable Mail Profile – Back to Basics

• by Monica Rathbun

• SQLEspresso

I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...

2019-03-13

251 reads