SQLEspresso

Quick SSMS Tip

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

Are My SQL Server Indexes Being Used?

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

2,010 reads

Comparing Execution Plans

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

802 reads

Filtered Index Basics

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

704 reads

Blogs

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

SQL Server 2019 on Docker no longer runs as root by default

By

In my home lab I have an Ubuntu virtual machine that runs both SQL...

SQL Server 2019 – Compatibility Level in Azure

By

I am not sure when this became available but for Azure SQL Database 150...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

A Good Reason to use a VCS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Good Reason to use...

Soft Skills: Controlling your career

By David.Poole

Comments posted to this topic are about the item Soft Skills: Controlling your career

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers