Hello Dear Reader! We had a beautiful weekend here in Florida. Spring is in the air, mainly because the temperature is ranging between 85 to 90 degrees Fahrenheit. This...
2023-02-27
25 reads
Today’s coping tip is to tell a loved one about the strengths you see in them. For one of my kids, I’m letting them know that I see: responsibility...
2023-02-27
23 reads
The Open Group Architecture Framework (TOGAF) is one of the most well-known architectural frameworks in our industry. TOGAF is a framework that helps organizations implement enterprise architecture as a...
2023-02-27
131 reads
This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group...
2023-03-10 (first published: 2023-02-27)
167 reads
SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management →
2023-02-27
377 reads
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
259 reads
In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color...
2023-02-25 (first published: 2023-02-24)
106 reads
I am saddened to report that I will not be able to attend SQLBits in person this year as originally planned. I was involved in a terrible car accident...
2023-02-24
44 reads
I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
19 reads
Today’s coping tip is to be gentle with someone you feel inclined to criticize. It’s very easy, and maybe very human, to start to criticize others for doing something...
2023-02-24
22 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