Anchormodeling's Pastebin

Stockholm 4,299 244,973 0 15 years ago

Name / Title	Added	Expires	Hits	Syntax
Setting up HLS-relay	Jan 19th, 2025	Never	238	None	-
The Intelligent Lake	Apr 15th, 2023	Never	336	None	-
Posits for ChatGPT	Dec 23rd, 2022	Never	248	None	-
Methods for the Row in Effect	Jan 22nd, 2022	Never	36,074	T-SQL	-
Bitemporal Test Suite	Sep 17th, 2021	Never	1,191	T-SQL	-
Data Condensation	Aug 8th, 2019	Never	1,628	T-SQL	-
Transitional Modeling 20181217.2	Dec 18th, 2018	Never	1,003	T-SQL	-
Transitional Modeling using SQL	Dec 17th, 2018	Never	945	T-SQL	-
Polymorphic Graph Queries in SQL Server	Jun 25th, 2018	Never	10,243	T-SQL	-
Random Name Generator	Feb 7th, 2018	Never	326	T-SQL	-
Optimizing BETWEEN joins	Feb 5th, 2018	Never	12,071	T-SQL	-
Source to Target Generator	Apr 28th, 2017	Never	17,108	T-SQL	-
Knot Loading Generator	Apr 21st, 2017	Never	17,377	T-SQL	-
Anchor Model Generator	Nov 15th, 2016	Never	22,909	T-SQL	-
Uniqueness constraints	Oct 12th, 2015	Never	30,337	T-SQL	-
The Iceberg Exercise	Sep 20th, 2015	Never	28,398	T-SQL	-
Do not materialize functions that are not subsequently used.	Sep 10th, 2013	Never	8,591	T-SQL	-
Consolidate Execution Plan Paths	Sep 10th, 2013	Never	8,635	T-SQL	-
Substitute Primary Keys	Sep 10th, 2013	Never	8,636	T-SQL	-
No table elimination for window functions	Sep 6th, 2013	Never	297	T-SQL	-
Example Stage (day 2): Merge Script	Sep 6th, 2013	Never	1,272	T-SQL	-
Example Stage (day 2): Step-by-step Script	Sep 6th, 2013	Never	1,268	T-SQL	-
Create source data - day 2	Sep 6th, 2013	Never	1,286	T-SQL	-
Example Stage (day 1): Step-by-step Script	Sep 6th, 2013	Never	2,718	T-SQL	-
Create example model database	Sep 6th, 2013	Never	6,845	T-SQL	-
Create source data - day 1	Sep 6th, 2013	Never	2,703	T-SQL	-
Example Stage (day 1): Merge Script	Sep 6th, 2013	Never	2,706	T-SQL	-
Materializing Multistatement Table-valued Function Result	Sep 6th, 2013	Never	274	T-SQL	-
Multistatement Table-valued Functions and Table Elimination	Sep 4th, 2013	Never	286	T-SQL	-
Evaluated JavaScript from sisula	Jun 18th, 2013	Never	1,324	T-SQL	-
JSON object from Anchor XML	Jun 18th, 2013	Never	1,318	JavaScript	-
Example of sisula	Jun 18th, 2013	Never	1,305	T-SQL	-
Concurrent-reliance-temporal	Jun 5th, 2013	Never	625	T-SQL	-
Temporal Uniqueness	Jun 12th, 2012	Never	337	T-SQL	-
Temporal Entity Integrity	Feb 24th, 2012	Never	988	T-SQL	-
Temporal Dimensional Modeling	Feb 19th, 2012	Never	1,143	T-SQL	-
Complex Bitemporal Test	Feb 16th, 2012	Never	903	T-SQL	-
Bitemporal triggers	Feb 15th, 2012	Never	837	T-SQL	-
Statistics for bit columns	Feb 2nd, 2012	Never	403	T-SQL	-
Subselect vs Group By	Feb 2nd, 2012	Never	348	T-SQL	-
Using the insert/update/delete triggers	Dec 11th, 2011	Never	697	T-SQL	-
Overflow partition and reserved value	Dec 9th, 2011	Never	414	T-SQL	-
Overflow partition and NULL values	Dec 8th, 2011	Never	482	T-SQL	-
Bitemporal Anchor Modeling 1C2R Partitioning	Nov 18th, 2011	Never	666	T-SQL	-
Bitemporal Anchor Modeling 1C2R Two Tables	Nov 17th, 2011	Never	505	T-SQL	-
Bitemporal Anchor Modeling 1C1R One Table	Aug 23rd, 2011	Never	551	T-SQL	-
Anchor Model	Mar 30th, 2011	Never	393	SQL	-
Teradata Table Elimination	Mar 27th, 2011	Never	517	SQL	-
PostgreSQL Table Elimination	Mar 27th, 2011	Never	1,064	PostgreSQL	-
DB2 Table Elimination	Mar 27th, 2011	Never	607	SQL	-
Oracle Table Elimination	Mar 27th, 2011	Never	605	Oracle 11	-
MSSQL Table Elimination	Mar 27th, 2011	Never	1,266	SQL	-
MySQL Table Elimination	Mar 27th, 2011	Never	720	SQL	-
MariaDB Table Elimination	Mar 27th, 2011	Never	1,019	SQL	-