SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
293 reads
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
293 reads
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
640 reads
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
355 reads
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
443 reads
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
353 reads
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
393 reads
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
380 reads
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,102 reads
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
315 reads
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
618 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