I’m speaking at SQL Saturday 553 in Oklahoma City
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...
2016-08-16
508 reads
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...
2016-08-16
508 reads
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second...
2016-08-18 (first published: 2016-08-11)
2,134 reads
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
614 reads
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
897 reads
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,019 reads
San Antonio is such a great city with a lot to see and do, such as the Alamo and the...
2016-07-23
359 reads
I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought....
2016-07-21
581 reads
Have you ever tried to query the contents of the default trace and then spent more time trying to figure...
2016-07-18
454 reads
If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is...
2016-07-18
294 reads
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...
2016-07-15
2,193 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...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
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