Does It Help
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
2011-10-14
114 reads
Editorials
The Contest That's Out of the World
Steve Jones talks about the most interesting contest, evah! Brought to you by Red Gate Software.
2011-10-13
112 reads
The Countdown
Steve Jones has a short piece today, about an announcement coming today at 10am PST during the PASS Summit.
2011-10-12
146 reads
The Half Day Experiment
A change at the PASS Summit this year has Steve Jones watching to see if it works out well for attendees and speakers.
2011-10-11
74 reads
A Nice Refund
This editorial was originally published on Sept 12, 2006. The IRS makes a $318mm mistake and Steve talks about the need to ensure that you don't do something similar.
2011-10-10
151 reads
2011-10-10
117 reads
The DR Test Schedule
Planning for disaster recovery entails a lot of different items, but testing is an important one. If you don't test your plans, you can't be sure they will work. This Friday Steve Jones asks how often your test.
2011-10-07
203 reads
Come Find Me at the Summit
Steve Jones reminds you to network anytime you're at and event, and especially a large conference like the PASS Summit.
2011-10-06
61 reads
An Awesome Job
Life is awesome, and Steve Jones things everyone can find something awesome in their jobs.
2011-10-05
454 reads
How do you learn the advanced stuff?
Today Steve Jones talks about learning those advanced features that you don't get the chance to use in your daily work.
2011-10-04
351 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
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...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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