Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,110 reads
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,110 reads
This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...
2010-12-27
949 reads
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,130 reads
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...
2010-12-21
700 reads
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...
2010-12-16
1,120 reads
This past Saturday I presented my shiny new Introduction to SQL Server Partitioning session at SQL Saturday 61.
There were two...
2010-12-07
690 reads
Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.
TSQL Tuesday #11: Misconceptions in SQL Server
This...
2010-10-12
991 reads
Yeah, you heard me.
Do you like to read?
“But Kendra, why would we want to grant developers read permissions? And why...
2010-08-16
914 reads
This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach?...
2010-07-13
1,333 reads
Data Collection, Puppy Style
Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some...
2010-06-26
1,719 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