SQL Puzzle 2: Eight Queens
This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned...
2019-04-26 (first published: 2017-07-19)
2,181 reads
This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned...
2019-04-26 (first published: 2017-07-19)
2,181 reads
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2019-04-26 (first published: 2017-08-22)
2,210 reads
I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...
2019-04-26 (first published: 2017-11-08)
1,431 reads
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2019-04-26 (first published: 2017-12-19)
1,623 reads
There was a bit of chat today on the SQL Community slack about UTC and Daylight Saving Time. It reminded...
2019-04-26 (first published: 2017-07-19)
2,539 reads
Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...
2019-04-26 (first published: 2017-03-13)
6,227 reads
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2019-04-26 (first published: 2017-06-20)
5,720 reads
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2019-04-26 (first published: 2017-07-25)
6,595 reads
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve...
2019-04-26 (first published: 2017-05-31)
1,963 reads
Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...
2019-04-26 (first published: 2018-09-25)
2,536 reads
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
Hi everyone I have a PowerShell script that is run by Execute Process Task...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers