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,662 reads
T-SQL
2020-04-23
838 reads
2020-04-20
870 reads
2020-04-16
622 reads
2020-04-07
723 reads
2020-03-30
561 reads
2020-03-24
549 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,548 reads
2020-03-10
886 reads
Gap Analysis Using Algebra
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
5,000 reads
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers