Problem Finding the hole for continuous sequences of numbers could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used function) specific designed for geometry objects. Sample: Given the following sequence of [dis]continuous numbers […]
2020-03-30
1,546 reads
2020-03-23
1,425 reads
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
2020-03-16
2,281 reads
Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]
2020-02-13
5,825 reads
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
2017-08-10
948 reads
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
2017-06-27
2,344 reads
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
This is kinda hard to explain, maybe I can make sense of it. So...
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...
Ask SSC