There’s no substitute for mentoring
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
343 reads
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
343 reads
The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one...
2017-05-22
397 reads
Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want...
2017-05-17
436 reads
On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and...
2017-04-04
343 reads
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like....
2017-03-25
326 reads
I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in...
2017-01-25
729 reads
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
826 reads
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
611 reads
Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...
2016-12-09
553 reads
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life...
2016-12-05
591 reads
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...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
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?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
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