SQLServerCentral Editorial

Another look at table variables

Becoming overly enthusiastic about a new SQL Server feature can backfire if you don’t do some testing. One example is the table variable introduced with SQL Server 2000. At the time, there was a myth that table variables would always perform better than temp tables with the reasoning that, by definition, variables are stored in […]

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

BCA KCP Reg.Tanah Abang TLP/WA 08218573837

By Sattamatka1

Ps. Regional Tanah Abang, Blok F, Lt. Dasar, Kp. Bali, Kecamatan Tanah Abang, Kota...

BCA KCP Pantai Indah Kapuk CSTelpon : 0853-73737551

By drsushmadikhit

CSTelpon : 0853-73737551 Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara,...

BCA KCP Sahid Sudirman Residence TLP/WA 08216977701

By Sattamatka1

Kantor Sahid Sudirman Residence, Jl. Jenderal Sudirman No.86 Lt. LG Unit 01, Karet Tengsin,...

Visit the forum

Question of the Day

The Distance Metric

In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?

See possible answers