Meme Monday: 11 Words or Less
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
729 reads
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
729 reads
SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...
2011-04-04
782 reads
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
636 reads
Backups Abound
The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-03-31
13,148 reads
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,722 reads
Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...
2011-02-26
1,769 reads
Overview
We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing...
2011-02-25
1,380 reads
Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...
2011-02-24
465 reads
Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a...
2011-02-23
733 reads
Overview
Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again,...
2011-02-23
689 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