Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]
2023-09-30
68 reads
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
165 reads
Take a moment and submit to be on the WIT panel at the PASS Data Community Summit in Seattle this November. We would like to see more women taking part in this.
2023-06-23
193 reads
This is a survey from us at dataplatformwit.com to understand why /how you, as a woman technologist are engaging with community. We ask that women in the data community please fill this out.
2023-04-12
120 reads
A week ago I was in Pasadena attending the SCaLE 20x conference, a gathering of many different open-source communities discussing the technologies and platforms that draw them together. I was fortunate enough to hear some excellent presentations on PostgreSQL and give two talks as well. After the first round of talks on Friday morning a […]
2023-03-18
124 reads
Helping others has been good for Steve's career and he encourages you to do it as well.
2022-09-16
145 reads
Steve is asking for others to contribute to the sqlmemorial site for our #sqlfamily.
2021-08-06
285 reads
We had unfortunately lost quite a few members of our SQL Family. We have a new way to remember them.
2021-01-27
171 reads
2021-01-02
100 reads
An organization, or an event, is more than just the name and structure. It's mostly the people.
2020-11-21
181 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
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