2020-09-30
162 reads
Editorials
Keeping Your Staff
Retaining staff is always a challenge for many organizations. Today Steve talks about the difficulties of doing so and in choosing who to retain.
2020-09-29
159 reads
Do You Know What the Settings Should Be?
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
2020-09-28
100 reads
New Stuff Can Be Scary
I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's […]
2020-09-26
116 reads
2020-09-25 (first published: 2016-09-16)
1,571 reads
The 10X Programmer
Today Steve Jones discusses the mythical 10x programmer from the context of databases.
2020-09-24 (first published: 2016-09-19)
303 reads
The Habits of Better Teams
Building a strong team is hard, and it takes work. A few thoughts today from Steve on how you can do this.
2020-09-23
126 reads
The New Normal Annoyances
Steve talks a bit about the new challenges of working in a different environment and the challenges you might face.
2020-09-22
117 reads
Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
374 reads
Would You Move For a Job?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?
2020-09-18 (first published: 2016-04-04)
274 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