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,469 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,677 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,620 reads
Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
513 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)
13,820 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,492 reads
Blogs
Power BI Monthly Digest – September 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA
By gbargsley
Happy Tuesday everyone… Today I am honored to have my first article published on...
Daily Coping 22 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SCOM/SCCM alert when Always On High Availability dashboard is green
Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the...
Restart SQL server from CMD
We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server...
Replication issue
my table is getting replicated from server 1 to server 2. I got a...
Ask SSC