Emmitt Albright

I have been working with SQL Server for more than 10 years as a database developer and report writer.

SQLServerCentral Article

Comparing Two Execution Plans

This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]

5 (6)

You rated this post out of 5. Change rating

2023-11-24 (first published: )

8,055 reads

SQLServerCentral Article

Fixing MLS Python Services to Load the Runtime

Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]

You rated this post out of 5. Change rating

2019-10-24

6,590 reads

SQLServerCentral Article

Key Rotation in TDE

Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]

You rated this post out of 5. Change rating

2019-08-29

12,998 reads

Blogs

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs

Forums

how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers