SQL Server 2008 - CDC Retention
I had done a little work with CDC last year, experimenting with the way that it handles changes in your...
2010-10-26
2,443 reads
I had done a little work with CDC last year, experimenting with the way that it handles changes in your...
2010-10-26
2,443 reads
There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL....
2010-10-26
1,068 reads
I was asked to host a T-SQL Tuesday, and I accepted.
Once again, my fingers move a bit faster than...
2010-10-25
729 reads
It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts...
2010-10-22
719 reads
No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday...
2010-10-21
681 reads
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
979 reads
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,304 reads
I saw a post recently from Hugo Shebbeare that reminded me of something that I’ve seen asked often on the...
2010-10-19
7,606 reads
This is actually amazing. A talk on what YouTube does with copyright and how they view it, from TED. It’s...
2010-10-18
1,117 reads
I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a...
2010-10-15
891 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