This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.

Operator of the Week - Lazy Spool

by Additional Articles

SimpleTalk

Execution Plans

Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.

The Phantom DBA

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?

SSAS: Explaining the State Transitions Viewer for Sequence Clustering

by Additional Articles

TechNet Blogs

Analysis Services (SSAS)

In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.

Concurrent processing in SSIS – Part 2

by Elliott Whitlow

SQLServerCentral.com

Integration Services (SSIS)

The second part of a series that looks at two additional techniques for processing data in parallel in Integration Services.

Dinosaur Databases

by Steve Jones

SQLServerCentral.com

Editorial

Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.

I’m a SQL Server DBA, and I’m in Love with PowerShell

by Additional Articles

SimpleTalk

PowerShell

To learn PowerShell, Laerte Junior suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice, "the lion is dead".