Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix...
2021-01-27
17 reads
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix...
2021-01-27
612 reads
I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan 29, 2021, with my friend Julie Koesmarno ( b | t ). I’ll be showing...
2021-01-27
28 reads
I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan 29, 2021, with my friend Julie Koesmarno ( b | t ). I’ll be showing...
2021-01-27
39 reads
Do you ever take a look at SSMS in the System Databases section? People that are new to SQL Server might or might not know much about these essential...
2021-02-04 (first published: 2021-01-26)
611 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-26
19 reads
When you don't have statistics, what does SQL use to calculate the estimated number of rows?
2021-02-04 (first published: 2021-01-26)
300 reads
This is a bit of a longer one, a look at how to do all the different joins and the exciting thing for MSSQL developers is that we get...
2021-01-25
15 reads
This is a bit of a longer one, a look at how to do all the different joins and the exciting thing for MSSQL developers is that we get...
2021-02-05 (first published: 2021-01-25)
163 reads
I had a customer recently ask about how to recover data from a backup file. I believe the request was for SQL Backup, but I knew there was another...
2021-02-02 (first published: 2021-01-25)
312 reads
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...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
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