Case Studies

Technical Article

Using SQL Server 2005 Integration Services in a Scalable Business Inte

  • Article

By using Microsoft® SQL Server™ 2005 Integration Services (SSIS) to perform metrics calculations on data extracted from the Siebel Call Center database, the cross-IT (XIT) group in Microsoft Information Technology (Microsoft IT) was able to replace a former reporting application with a new scalable and flexible reporting application to improve reporting throughout the organization

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-02-14

1,956 reads

Technical Article

High Call Volume SQL Server Applications on NUMA Systems

  • Article

One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-10-25

1,754 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

By

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203

By layanan_Bca88

Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...

Alamat BCA KCP Kyai Caringin Telp:0821°8200°233

By R4nt4u

Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...

Alamat BCA KCP Tanah Abang Blok A Telp:0821°7555°651

By m4rt1n4

Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers