Building Better VMs
The other day I fired up my old desktop, intending to use it as background in the podcasts. It gave...
2008-07-22
995 reads
The other day I fired up my old desktop, intending to use it as background in the podcasts. It gave...
2008-07-22
995 reads
It's been a while since I had anything up on SSC, a combination of Steve being in good shape on...
2008-07-22
479 reads
I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on...
2008-07-21
532 reads
Call me odd, but I enjoy taking certification tests. It may be that I've always tested well, or perhaps it's...
2008-07-20
662 reads
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
844 reads
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,904 reads
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
507 reads
We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting....
2008-07-17
700 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,161 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,353 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...
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