anchormodeling

Anchormodeling's Pastebin

Stockholm    953 186,927 9 years ago
Name / Title Added Expires Hits Syntax  
Data Condensation Aug 8th, 2019 Never 780 T-SQL -
Transitional Modeling 20181217.2 Dec 18th, 2018 Never 163 T-SQL -
Transitional Modeling using SQL Dec 17th, 2018 Never 344 T-SQL -
Polymorphic Graph Queries in SQL Server Jun 25th, 2018 Never 9,278 T-SQL -
Random Name Generator Feb 7th, 2018 Never 97 T-SQL -
Optimizing BETWEEN joins Feb 5th, 2018 Never 11,553 T-SQL -
Source to Target Generator Apr 28th, 2017 Never 16,378 T-SQL -
Knot Loading Generator Apr 21st, 2017 Never 16,615 T-SQL -
Anchor Model Generator Nov 15th, 2016 Never 22,103 T-SQL -
Uniqueness constraints Oct 12th, 2015 Never 29,879 T-SQL -
The Iceberg Exercise Sep 20th, 2015 Never 27,626 T-SQL -
Do not materialize functions that are not subseque... Sep 10th, 2013 Never 8,170 T-SQL -
Consolidate Execution Plan Paths Sep 10th, 2013 Never 8,197 T-SQL -
Substitute Primary Keys Sep 10th, 2013 Never 8,209 T-SQL -
No table elimination for window functions Sep 6th, 2013 Never 58 T-SQL -
Example Stage (day 2): Merge Script Sep 6th, 2013 Never 950 T-SQL -
Example Stage (day 2): Step-by-step Script Sep 6th, 2013 Never 959 T-SQL -
Create source data - day 2 Sep 6th, 2013 Never 986 T-SQL -
Example Stage (day 1): Step-by-step Script Sep 6th, 2013 Never 2,323 T-SQL -
Create example model database Sep 6th, 2013 Never 6,107 T-SQL -
Create source data - day 1 Sep 6th, 2013 Never 2,326 T-SQL -
Example Stage (day 1): Merge Script Sep 6th, 2013 Never 2,310 T-SQL -
Materializing Multistatement Table-valued Function... Sep 6th, 2013 Never 49 T-SQL -
Multistatement Table-valued Functions and Table El... Sep 4th, 2013 Never 57 T-SQL -
Evaluated JavaScript from sisula Jun 18th, 2013 Never 949 T-SQL -
JSON object from Anchor XML Jun 18th, 2013 Never 963 JavaScript -
Example of sisula Jun 18th, 2013 Never 946 T-SQL -
Concurrent-reliance-temporal Jun 5th, 2013 Never 229 T-SQL -
Temporal Uniqueness Jun 12th, 2012 Never 87 T-SQL -
Temporal Entity Integrity Feb 24th, 2012 Never 660 T-SQL -
Temporal Dimensional Modeling Feb 19th, 2012 Never 696 T-SQL -
Complex Bitemporal Test Feb 16th, 2012 Never 558 T-SQL -
Bitemporal triggers Feb 15th, 2012 Never 492 T-SQL -
Statistics for bit columns Feb 2nd, 2012 Never 173 T-SQL -
Subselect vs Group By Feb 2nd, 2012 Never 138 T-SQL -
Using the insert/update/delete triggers Dec 11th, 2011 Never 402 T-SQL -
Overflow partition and reserved value Dec 9th, 2011 Never 131 T-SQL -
Overflow partition and NULL values Dec 8th, 2011 Never 140 T-SQL -
Bitemporal Anchor Modeling 1C2R Partitioning Nov 18th, 2011 Never 210 T-SQL -
Bitemporal Anchor Modeling 1C2R Two Tables Nov 17th, 2011 Never 179 T-SQL -
Bitemporal Anchor Modeling 1C1R One Table Aug 23rd, 2011 Never 287 T-SQL -
Anchor Model Mar 30th, 2011 Never 166 SQL -
Teradata Table Elimination Mar 27th, 2011 Never 297 SQL -
PostgreSQL Table Elimination Mar 27th, 2011 Never 793 PostgreSQL -
DB2 Table Elimination Mar 27th, 2011 Never 361 SQL -
Oracle Table Elimination Mar 27th, 2011 Never 389 Oracle 11 -
MSSQL Table Elimination Mar 27th, 2011 Never 1,032 SQL -
MySQL Table Elimination Mar 27th, 2011 Never 490 SQL -
MariaDB Table Elimination Mar 27th, 2011 Never 657 SQL -