Monica Rathbun

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

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

679 reads

DMV’s for the Beginner

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

1,761 reads

What is Implicit Conversion?

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

948 reads

What’s a Key Lookup?

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

661 reads

Women in Tech Talk Tech

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

1,002 reads

Blogs

What does the Machine Learning process look like?

By

This is the second article in the Machine Learning area. I have explained a...

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Read the latest Blogs

Forums

Container Ports

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Container Ports

Receiving timeout errors on SQL2014

By Dhruva_51

Similar to the one mentioned in the below article. We are sql server build...

Continue SQL Server transactional replication with AWS DMS

By tttcoding

Hello, I have a task for which I wasn't able to find much information...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers