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)
3,905 reads
Alessandro Mortola
A Plunge Into TOP
Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
4,812 reads
Self SQL Injection
Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises
2018-04-30
1,652 reads
Indexing Foreign Keys
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?
2016-09-16 (first published: 2015-06-29)
14,181 reads
Cardinality Estimator – What’s new in SQL Server 2014
SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.
2015-04-09
6,543 reads
Blogs
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours....
Azure Arc
By Vinay Thakur
Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Forums
AOAG with FCI Step by Step
It's been a very long while since I have set this all up. I...
how to get GPNSignature that first part on it start by portion key ?
I work on sql server 2012 I face issue i can't get GPNSignature that...
Multiple .ndf file in single disk
I have moved some of my database to SQL server 2017 (RTM) - Standard...
Ask SSC