SQL Saturday #71: Call For Speakers
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we...
2011-01-26
1,027 reads
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we...
2011-01-26
1,027 reads
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a...
2011-01-21
774 reads
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or,...
2011-01-21
881 reads
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,653 reads
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
726 reads
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown...
2011-01-11
996 reads
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
580 reads
Originally submitted at SCOTTEVEST, Inc.
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began...
2011-01-05
1,616 reads
This is a temporary post that was not deleted. Please delete this manually. (95b57a7c-aa49-471e-a63c-76ea6775d1d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-01-04
516 reads
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
781 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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