SQLEspresso

In Memory Table Indexes

• by Monica Rathbun

• SQLEspresso

Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables....

2020-01-22

16 reads

Memory Optimizer Advisor

• by Monica Rathbun

• SQLEspresso

Previously I wrote about In-Memory Optimized Tables, in this blog I am going to discuss how to determine which tables could benefit from being In-Memory by using a tool...

2020-01-23 (first published: 2020-01-15)

316 reads

Memory Optimized Tables in SQL Server

• by Monica Rathbun

• SQLEspresso

Sometimes when I try to learn about a concept my brain blocks out everything about it. Talking about anything that uses the “In Memory” concept tends to do this...

2020-01-16 (first published: 2020-01-08)

694 reads

Trace Flags That Are Now Defaulted Behaviors in SQL Server

• by Monica Rathbun

• SQLEspresso

If you have ever attended one of my performance tuning sessions, you know I tend to talk about  trace flags.  Trace Flags can help fix performance issues and some...

2019-12-18

197 reads

Introduction to the performance features on SQL Server on Linux

• by Monica Rathbun

• SQLEspresso

I’ve been tinkering with SQL Server on Linux lately and noted a few things in regards to performance I thought I would share with you. SQL Server 2019 on...

2019-12-04

262 reads

Install ALL Things SQL Server… What?

• by Monica Rathbun

• SQLEspresso

Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...

2019-12-10 (first published: 2019-11-26)

819 reads

Simple-Talk Article…Understanding Azure Storage Options

• by Monica Rathbun

• SQLEspresso

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of being a guest Author and explain Azure storage options. I cover types of storage accounts,...

2019-11-20

123 reads

I’m Speaking at Pass Summit 2019

• by Monica Rathbun

• SQLEspresso

I am very excited to be heading to PASS Summit 2019 in Seattle next week. It’s one of my favorite weeks of the year. Getting to hang out with...

2019-11-01

14 reads

Invest in Yourself Stop Making Excuses

• by Monica Rathbun

• SQLEspresso

Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write...

2019-11-08 (first published: 2019-10-22)

1,441 reads

The FAST number_rows Query Hint

• by Monica Rathbun

• SQLEspresso

Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...

2019-10-29 (first published: 2019-10-16)

968 reads