Department of Redundancy DepartmentEver wonder all the reasons that we use databases instead of file systems? While we don’t think […] 18 mars 2024 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Two-Dimensional Interval Packing ChallengePacking intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […] 2 janvier 2024 dans Sites anglophones étiqueté Homepage / T-SQL Programming / Theory and design par simple-talk.com
Eager Aggregation in SQL queriesAggregation is a widely used way to summarize the content of a database. It is usually expressed […] 27 décembre 2023 dans Sites anglophones étiqueté Homepage / PostGreSQL / Theory and design par simple-talk.com
Using a SQL TokenizerImagine this: you have several directories full of SQL script files, and you need to know where […] 18 décembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
When an update doesn’t updateTell me if you’ve heard this one before: I changed data from my application, but when I […] 27 novembre 2023 dans Sites anglophones étiqueté Homepage / T-SQL Coding / T-SQL Programming / Theory and design par simple-talk.com
The NTILE FunctionThe SQL NTILE() is a window function that allows you to break a table into a specified […] 9 novembre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
First Normal Form Gets No RespectDr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […] 5 octobre 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
T-SQL Fundamentals: Controlling DuplicatesWhen people start learning a new field, for example T-SQL, it’s tempting to spend very little time […] 28 septembre 2023 dans Sites anglophones étiqueté Homepage / SummitSpeaker2023ItzikBenGan / T-SQL Programming / Theory and design par simple-talk.com
The GROUP BY ClauseWhen you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […] 10 juillet 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
Getting Out of CharacterPre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […] 28 février 2023 dans Sites anglophones étiqueté Homepage / Theory and design par simple-talk.com
The VALUES clause or building tables out of nothingThe VALUES clause is probably one of the most misused features in SQL. If you look at […] 23 mai 2022 dans Sites anglophones étiqueté Homepage / SQL Prompt / Theory and design par simple-talk.com