SQLEspresso

Resizing Tempdb (When TEMPDB Wont Shrink)

• by Monica Rathbun

• SQLEspresso

Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...

2020-09-16 (first published: 2020-09-09)

690 reads

Resizing Tempdb (When TEMPDB Wont Shrink)

• by Monica Rathbun

• SQLEspresso

Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...

2020-09-09

Adaptive Joins in SQL Server

• by Monica Rathbun

• SQLEspresso

SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...

2020-09-10 (first published: 2020-09-02)

1,271 reads

Adaptive Joins in SQL Server

• by Monica Rathbun

• SQLEspresso

SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...

2020-09-02

Change Azure SQL Database Service Level Objectives in SSMS

• by Monica Rathbun

• SQLEspresso

Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...

2020-09-08 (first published: 2020-08-28)

189 reads

Change Azure SQL Database Service Level Objectives in SSMS

• by Monica Rathbun

• SQLEspresso

Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...

2020-08-28

Caution When Dropping Unused Indexes on an Azure SQL Database

• by Monica Rathbun

• SQLEspresso

Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...

2020-08-24 (first published: 2020-08-12)

578 reads

Caution When Dropping Unused Indexes on an Azure SQL Database

• by Monica Rathbun

• SQLEspresso

Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...

2020-08-12

What is Azure SQL Database Serverless?

• by Monica Rathbun

• SQLEspresso

What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...

2020-07-01

229 reads

What is Azure SQL Database Serverless?

• by Monica Rathbun

• SQLEspresso

What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...

2020-07-01

1 reads