TSQL Challenge 33 - Calculate list of bookings fully paid on the book
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.
2010-06-28
1,598 reads
Articles
Operator of the Week - Lazy Spool
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.
2010-06-28
2,774 reads
SSAS: Explaining the State Transitions Viewer for Sequence Clustering
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.
2010-06-25
2,023 reads
Concurrent processing in SSIS – Part 2
The second part of a series that looks at two additional techniques for processing data in parallel in Integration Services.
2010-06-24
6,736 reads
I’m a SQL Server DBA, and I’m in Love with 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".
2010-06-24
5,883 reads
2010-06-23 (first published: 2008-12-24)
37,413 reads
Late June 2010 PASS VC Presentations
PASS BI and DBA Virtual Chapters have free training available on Wednesday June 23rd.
2010-06-23
477 reads
Using the UPTIME Utility to Monitor Servers
Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.
2010-06-23
8,401 reads
Voting opens for Exceptional DBA of 2010
The voting for the 2010 Exceptional DBA opens today, and you can read about the finalists and prizes inside.
2010-06-23
671 reads
Making your SQL Server database changes backward compatible: Adding a new column
As multi-tier architectures grow over time, it is often challenging to coordinate those changes across the data, logic and presentation tiers. Unless planned and implemented carefully, an act as simple as adding a column to a table can grind all of the components of your application to a halt. While some of us have comfortable 12-hour maintenance windows every weekend, many of us are bound by service level agreements that are much more strict. So we must find ways to introduce fixes and new features with zero downtime, and without requiring every single component to be refactored at the same time.
2010-06-23
3,366 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kapuk Muara Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara,...
BCA KCP Kapuk Muara Tlp (+62 821°3111°179
Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara, Kecamatan...
BCA KCP Maranatha No.Tlp.083179431643
Jl. Prof. Drg Jl. Prof. drg. Soeria Soemantri No.33, Sukawarna, Sukajadi, Bandung City, West...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers