Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
10 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
11 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
13 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
6 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
12 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
11 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
12 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
28 reads
Daily Coping 25 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-25
22 reads
Retrieving Log Analytics Data with Data Factory
I’ve been working on a project where I use Azure Data Factory to retrieve data from the Azure Log Analytics API. The query language used by Log Analytics is...
2021-01-05 (first published: 2020-12-24)
409 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers