SQLEspresso

SQL Server Statistics Health Reminder

• by Monica Rathbun

• SQLEspresso

I’ve written about statistics in SQL Server a few times now. Through conversations  I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...

2019-09-18

9 reads

Quick SSMS Tip

• by Monica Rathbun

• SQLEspresso

It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...

2019-09-11

158 reads

What SQL Server Performance & Management Tools Do I Use?

• by Monica Rathbun

• SQLEspresso

Several times I’ve been asked what tools are in my performance tuning and SQL Server management arsenal, so I decided to just create this blog to list them out...

2019-09-04

314 reads

Are My SQL Server Indexes Being Used?

• by Monica Rathbun

• SQLEspresso

Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...

2019-09-11 (first published: 2019-08-28)

2,010 reads

Keep It Simple Stupid

• by Monica Rathbun

• SQLEspresso

Some of us take days and weeks to write a blog, while others can take two minutes and write a great blog *cough* *cough* Denny (B|T). Why is that?...

2019-07-24

21 reads

Understanding Columnstore Indexes in SQL Server Part 3

• by Monica Rathbun

• SQLEspresso

My last two blogs were on understanding columnstore and creating columnstore indexes. In this post, I will touch on one last topic, when to use columnstore indexes. As noted...

2019-08-05 (first published: 2019-07-17)

559 reads

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-31 (first published: 2019-07-10)

392 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)

789 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)

802 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)

704 reads