2019-08-06
324 reads
Editorials
2019-08-05
304 reads
Best Practices and Band Plans
Grant Fritchey explains how database best practices should be followed more like those in Ham radio.
2019-08-03
469 reads
2019-08-02
377 reads
The Problem with Users
Users cause lots of security issues, and we ought to try to work within that framework, with the understanding the we can't prevent all problems.
2019-08-01
210 reads
2019-07-31 (first published: 2015-11-23)
549 reads
Working with People
One of the more important things that we can do as a professional is learn to work we well with others.
2019-07-30 (first published: 2015-09-09)
398 reads
More MVPs Than Awards
Every year, July 1 is the Microsoft MVP Renewal date and quite a few people received good news that day. I was one of those renewed for another year, and I am honored that Microsoft chose me again. I also congratulate all the others that received the award for the first time as well as […]
2019-07-29
281 reads
SQL Server 2019 CTP 3.2 Available
Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
2019-07-27
743 reads
2019-07-26 (first published: 2015-08-28)
585 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
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