External Article

Controlling Execution Plans with Hints

The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time. Grant Fritchey, in a chapter from his highly acclaimed book, explains further.

External Article

Using the SQL Server Analysis Services (SSAS) Deployment Wizard

I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?

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 Klender CSTelpon : 0853-73737551

By drsushmadikhit

Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota Jakarta...

BCA KCP Dewi Sartika CSTelpon : 0853-73737551

By drsushmadikhit

Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus...

BCA KCP Permata Ujung Menteng CSTelpon : 0853-73737551

By drsushmadikhit

CSTelpon : 0853-73737551 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...

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