2020-04-27
664 reads
T-SQL
A Solution for the Bin Packing Problem
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
2020-05-14 (first published: 2020-04-23)
5,518 reads
2020-04-23
828 reads
2020-04-20
868 reads
2020-04-16
619 reads
2020-04-07
718 reads
2020-03-30
558 reads
2020-03-24
545 reads
Combining many crossing intervals
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
2020-03-16
2,529 reads
2020-03-10
883 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers