Change Data Capture
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,148 reads
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,148 reads
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
439 reads
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
975 reads
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
335 reads
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals...
2008-02-11
1,344 reads
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
784 reads
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
494 reads
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past...
2008-02-11
556 reads
I was doing some development on my laptop tonight and I was getting fed up with the default font, Courier...
2008-02-09
3,489 reads
Actually more it's "our way" as mentioned in Andy's post, and less my way than by committee these days with...
2008-02-08
797 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...
Carisol 350mg is the main ingredient. Its powerful formulation, which includes the active ingredient...
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?
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