Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2023-06-14 (first published: 2023-05-31)
631 reads
A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few...
2023-06-19 (first published: 2023-05-31)
165 reads
Recently I got a message that my Evernote subscription was going up. It’s been a $3 a month service, but moving to $4 for me. From USD$35 to USD$50...
2023-05-30
1,175 reads
A customer had a question recently on masking Chinese characters. I thought that was interesting, so decided to test this out. This is a short post on using SQL...
2023-06-16 (first published: 2023-05-26)
175 reads
looseleft – the feeling of loss upon finishing a good book, sensing the weight of the back cover locking away the lives of characters you’ve gotten to know so...
2023-05-26
296 reads
I have been experimenting more and more with ChatGPT on a regular basis. I’m interested and curious how this will help. I had a friend at one of the...
2023-05-26
44 reads
I have been living with ALS for the past two years. I was diagnosed in September 2022 but had my first symptoms and started researching what was going on...
2023-06-09 (first published: 2023-05-25)
138 reads
I’m going to attend the Denver Dev Days 2023 in June. I submitted a few sessions and got two picked. I’ll be doing these talks: Blogging for the Tech...
2023-05-25
10 reads
I delivered a presentation for the Houston SQL Server User Group tonight, virtually from Colorado. I’d love to go down, but couldn’t do it today. The slides for the...
2023-05-25
30 reads
Setting up a local web server was something that I haven’t done in a long time and this was really easy. This post shows how to do this with...
2023-05-24
189 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
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