The VALUES clause or building tables out of nothing
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
2022-07-01
Design and Theory
Combinations, permutations, and derangements
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.
2022-06-01
The problem with averages
Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.
2022-03-25
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Constraints and declarative referential integrity
Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.
2021-05-28
2019-10-31
895 reads
2019-07-19
940 reads
2012-10-31
2,526 reads
2011-09-07
2,319 reads
2011-06-14
2,494 reads
Blogs
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Forums
The Growth of IQP
Comments posted to this topic are about the item The Growth of IQP
How to work with Python in Azure Data Studio
Comments posted to this topic are about the item How to work with Python...
Default Raiserror Levels
Comments posted to this topic are about the item Default Raiserror Levels
Ask SSC