SQL Saturday #167 – Columbus GA
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,710 reads
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,710 reads
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,803 reads
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-30
4,353 reads
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,525 reads
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
797 reads
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a...
2012-05-17
592 reads
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
642 reads
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
760 reads
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
633 reads
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,002 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...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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
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