External Article

Benefits and Limitations of SCHEMABINDING Views in SQL Server

The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?

SQLServerCentral Editorial

Distracted

I've found myself to be very distracted this week. Concentration on the task at hand has proven to be a challenge. I'm pretty sure the cause is that I just came off of three weeks of travel, which can be exhausting. Concentration, like so many things in life, requires energy. No energy, no concentration. So, […]

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 Pasar Puri Indah Telp/WA.0821°3111°179

By gi8hey

Telp/WA.0821°3111°179 Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta...

BCA KCP Taman Sari Telp/WA.0821°3111°179

By gi8hey

Telp/WA.0821°3111°179 Jl. Taman Sari Raya 47-47A, Taman Sari, Kec. Taman Sari, Kota Jakarta Barat,...

BCA KCP Intercon Megah Telp/WA.0821°3111°179

By gi8hey

Telp/WA.0821°3111°179 Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec. Kembangan, Kota Jakarta...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers