2011-11-22
2,653 reads
T-SQL
Dealing with Incomplete Data - A T-SQL Puzzle 1
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
2011-11-22
4,276 reads
2011-11-21
2,420 reads
2011-11-17
2,508 reads
2011-11-03
2,764 reads
2011-10-24
2,816 reads
Compare 2 datasets and output delta in one TSQL statement
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,315 reads
2011-10-21
2,608 reads
2011-11-01 (first published: 2011-10-18)
2,557 reads
2011-10-18
2,666 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 Thamrin Nine Telpon/WA:087768193341
BCA KCP Thamrin Nine Telpon/WA:087768193341.Thamrin Nine Podium Area - UG Unit A, Jl. MH...
BCA KCP KEM Tower Telpon/WA:087768193341
BCA KCP KEM Tower Telpon/WA:087768193341.Kem Tower, Gedung, Jl. Landas Pacu Barat No.Blok B Kav....
BCA KCP Relasi Indah,Telpon/Wa 0821-8200-239
Jl. Jl.Panjang. Panjang Arteri Klp. Dua Raya No.11, Klp. Dua, Kec. Kb. Jeruk, Kota...
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