External Article

Convert Implicit and the related performance issues with SQL Server

I was a running a routine query using an equal operator on the only column of the primary key for a table and I noticed that the performance was terrible. These queries should have been flying because all I was doing was retrieving one row of data which should have been doing an index seek. When I looked at the query plan it was doing a scan instead. This tip shows you what I found and how to resolve the problem.

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCU BEKASI. Tlp/wa:0853.7373.7845

By Markthomsan96

Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa Barat...

BCA KCP Cipto Mangunkusumo TLP/CS 08216977701

By Call Center Cs BRI QLola

Jl. DR. Cipto Mangunkusumo No.4E, Pekiringan, Kec. Kesambi, Kota Cirebon, Jawa Barat 45131

BCA KCU SUNTER HUB.Tlpn.0821•3111•185

By greatdubai02

BCA KCU SUNTER HUB.Tlpn.0821•3111•185 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers