EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
167 reads
In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...
2023-02-01 (first published: 2023-01-23)
481 reads
Today’s coping tip is to take a different route today and see what you notice. I’ve had this tip come up a few times and each time I’ve enjoyed...
2023-01-20
17 reads
Today’s coping tip is to switch off tech an hour before bedtime. I read at night often, so this is a challenging one. However, I decided to give this...
2023-01-19
24 reads
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop
The post Impact of Eliminating...
2023-01-27 (first published: 2023-01-18)
302 reads
I’ve been doing a bit of work with PostgreSQL as part of my work with Redgate. PostgreSQL is a relational platform that is open source, free to use, available...
2023-01-18
67 reads
I’m speaking at VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel a new place for me. I’m...
2023-01-18
21 reads
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
82 reads
Today’s coping tip is to say positive things to the people you meet today. In general, I don’t encounter a lot of people on any day, but I do...
2023-01-18
18 reads
Today’s coping tip is to get moving. Ideally do something outside. Taking time to walk the dogs outside, heading to the dog park to get them, and me, some...
2023-01-18
25 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