2014-10-14
1,722 reads
T-SQL
2014-10-13
2,141 reads
2014-10-10
1,691 reads
2014-10-09
2,211 reads
2014-10-08
1,994 reads
2014-10-06
1,627 reads
2014-10-03
2,046 reads
2014-11-10 (first published: 2014-10-01)
1,354 reads
2014-10-01
2,037 reads
Filling In Missing Values Using the T-SQL Window Frame
Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.
2014-10-01
11,294 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Finance WTC Mangga Dua Hub.0853•5504•2311
BCA Finance WTC Mangga Dua Hub.0853•5504•2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
BCA KCP Arundina Cibubur Hub.0853•5504•2311
BCA KCP Arundina Cibubur Hub.0853•5504•2311 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
BCA KCP Riau Bisnis Center TLP/WA 08216977749
Jl. Riau No.36, Tampan, Kec. Payung Sekaki, Kota Pekanbaru, Riau 28292
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers