You’re doing your POC wrong! : T-SQL Tuesday #152
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
376 reads
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
376 reads
I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading
2022-07-20 (first published: 2022-07-07)
417 reads
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
29 reads
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You ... Continue reading
2022-06-30
94 reads
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
19 reads
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
457 reads
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
321 reads
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
68 reads
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
21 reads
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data ... Continue reading
2022-06-15 (first published: 2022-05-31)
227 reads
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
hi we run 2019 std. we saw this week that someone hid 3 important...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers