corpus.blog
41554 blogs · [ { "id": "01a0d1d5-1a54-7081-b168-b4812009d620", "title": "Windowed DISTINCT aggregates", "url": "https://sqlsunday.com/2016/04/26/windowed-distinct-aggregates/", "published_at": "2016-04-26T05:00:38+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b48120a39179", "title": "Last row per group", "url": "https://sqlsunday.com/2016/04/11/last-row-per-group/", "published_at": "2016-04-11T06:00:32+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b4812132d53f", "title": "Catching circular references in parent-child structures", "url": "https://sqlsunday.com/2016/04/04/catching-circular-references/", "published_at": "2016-04-04T20:49:05+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b481213fe217", "title": "Different query plans for “OR” type queries", "url": "https://sqlsunday.com/2016/03/23/query-plans-for-or-queries/", "published_at": "2016-03-23T22:43:03+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b48121c7f5f3", "title": "Using UPDATE STATISTICS to fake row counts", "url": "https://sqlsunday.com/2016/02/27/update-statistics-with-rowcount/", "published_at": "2016-02-27T16:03:39+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b4812213b334", "title": "Intermittent conversion issues", "url": "https://sqlsunday.com/2016/02/17/intermittent-conversion-issues/", "published_at": "2016-02-17T13:29:47+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b48122428ad5", "title": "Median and percentile in T-SQL", "url": "https://sqlsunday.com/2016/02/11/median-and-percentile-in-tsql/", "published_at": "2016-02-11T08:45:21+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b48122ca4c75", "title": "Migrating a database from Enterprise to Standard Edition?", "url": "https://sqlsunday.com/2016/02/06/migrating-a-database-from-enterprise-to-standard-edition/", "published_at": "2016-02-06T22:16:20+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b481236b31ca", "title": "PIVOT, UNPIVOT and performance", "url": "https://sqlsunday.com/2016/01/29/pivot-unpivot-and-performance/", "published_at": "2016-01-28T23:04:36+00:00" }, { "id": "01a0d1d5-1a54-7081-b168-b48123acc187", "title": "The 2015 Swedish SQL Server usergroup challenge", "url": "https://sqlsunday.com/2015/12/10/the-2015-swedish-sql-server-usergroup-challenge/", "published_at": "2015-12-10T06:16:06+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e73817452280", "title": "The 2014 Swedish SQL Server usergroup challenge", "url": "https://sqlsunday.com/2014/12/11/sqlug-challenge-2014/", "published_at": "2014-12-11T11:53:33+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e7381752bc4e", "title": "Segment and Sequence Project", "url": "https://sqlsunday.com/2014/12/07/segment-and-sequence-project/", "published_at": "2014-12-07T07:00:45+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e73817b7ac90", "title": "Joining two SCD2 tables", "url": "https://sqlsunday.com/2014/11/30/joining-two-scd2-tables/", "published_at": "2014-11-30T07:00:15+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e738180fa2a0", "title": "Parallel execution, part 3", "url": "https://sqlsunday.com/2014/11/23/parallel-execution-part-3/", "published_at": "2014-11-23T07:00:10+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e7381832435b", "title": "Parallel execution, part 2", "url": "https://sqlsunday.com/2014/11/16/parallel-execution-part-2/", "published_at": "2014-11-16T07:00:59+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e73818f0fe48", "title": "Parallel execution, part 1", "url": "https://sqlsunday.com/2014/11/09/parallel-execution-part-1/", "published_at": "2014-11-09T07:00:36+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e73819bfe1b6", "title": "Using memory optimized tables on VirtualBox", "url": "https://sqlsunday.com/2014/11/02/memory-optimized-tables-on-virtualbox/", "published_at": "2014-11-02T07:00:37+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e73819e83abc", "title": "Distributing values with overlapping ranges", "url": "https://sqlsunday.com/2014/10/19/distributing-values-with-overlapping-ranges/", "published_at": "2014-10-19T06:00:47+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e7381a07cdc8", "title": "Manual transaction management", "url": "https://sqlsunday.com/2014/10/12/manual-transaction-management/", "published_at": "2014-10-12T06:00:38+00:00" }, { "id": "01a0d1d5-4570-73ce-bfbf-e7381a343b7f", "title": "Viewing the size of your database objects", "url": "https://sqlsunday.com/2014/10/05/viewing-size-of-database-objects/", "published_at": "2014-10-05T06:00:56+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dba04a98", "title": "User options and connection flags", "url": "https://sqlsunday.com/2014/09/28/connection-flags/", "published_at": "2014-09-28T06:00:50+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dc76e257", "title": "Identifiers in T-SQL", "url": "https://sqlsunday.com/2014/09/21/identifiers-in-tsql/", "published_at": "2014-09-21T06:00:25+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dd68a467", "title": "How to build a histogram in T-SQL", "url": "https://sqlsunday.com/2014/09/14/histogram-in-t-sql/", "published_at": "2014-09-14T06:00:12+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dd873393", "title": "Using MERGE as a single INSERT or UPDATE", "url": "https://sqlsunday.com/2014/09/07/using-merge-as-insert-or-update/", "published_at": "2014-09-07T06:00:52+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47de21fb88", "title": "Partitioned views over table partitioning", "url": "https://sqlsunday.com/2014/08/31/partitioned-views/", "published_at": "2014-08-31T06:00:12+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dee15742", "title": "Reloading fact tables with zero downtime", "url": "https://sqlsunday.com/2014/08/24/reloading-fact-tables-with-zero-downtime/", "published_at": "2014-08-24T06:00:44+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dee9689a", "title": "Calculating 30/360 day count convention", "url": "https://sqlsunday.com/2014/08/17/30-360-day-count-convention/", "published_at": "2014-08-17T06:00:05+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dfd98a97", "title": "The SQL Server security model, part 4: execution context", "url": "https://sqlsunday.com/2014/08/10/the-sql-server-security-model-part-4/", "published_at": "2014-08-10T06:00:10+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47dffe7fbf", "title": "The SQL Server security model, part 3: permissions", "url": "https://sqlsunday.com/2014/08/03/the-sql-server-security-model-part-3/", "published_at": "2014-08-03T06:00:46+00:00" }, { "id": "01a0d1d5-69da-708f-bf9e-1d47e0fceed0", "title": "The SQL Server security model, part 2: securables", "url": "https://sqlsunday.com/2014/07/27/the-sql-server-security-model-part-2/", "published_at": "2014-07-27T06:00:42+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c751def87", "title": "The SQL Server security model, part 1: principals", "url": "https://sqlsunday.com/2014/07/20/the-sql-server-security-model-part-1/", "published_at": "2014-07-20T06:00:52+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c75c2f3c7", "title": "Building a calendar dimension with public holidays", "url": "https://sqlsunday.com/2014/07/13/calendar-dimension-with-public-holidays/", "published_at": "2014-07-13T06:00:31+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c76995b8e", "title": "Calculating the date of easter sunday", "url": "https://sqlsunday.com/2014/07/06/calculating-easter/", "published_at": "2014-07-06T06:00:06+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c778567d8", "title": "Inline variable assignment in UPDATE statements", "url": "https://sqlsunday.com/2014/06/29/inline-variable-assignment-in-update/", "published_at": "2014-06-29T06:00:13+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7851169f", "title": "Schemabinding and table spools", "url": "https://sqlsunday.com/2014/06/22/schemabinding-and-table-spools/", "published_at": "2014-06-22T06:00:17+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7862d5b9", "title": "Blocking/non-blocking aggregate operators", "url": "https://sqlsunday.com/2014/06/15/blocking-aggregate-operators/", "published_at": "2014-06-15T06:00:41+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7955c994", "title": "Datawarehouse modelling: Inmon vs Kimball", "url": "https://sqlsunday.com/2014/06/08/inmon-vs-kimball/", "published_at": "2014-06-08T06:00:51+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7a3ea9aa", "title": "HASH JOIN deep-dive", "url": "https://sqlsunday.com/2014/06/01/hash-join-deep-dive/", "published_at": "2014-06-01T06:00:20+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7a93dc02", "title": "Directed acyclic graphs vs parent-child hierarchies", "url": "https://sqlsunday.com/2014/05/25/directed-acyclic-graphs-vs-parent-child-hierarchies/", "published_at": "2014-05-25T06:00:48+00:00" }, { "id": "01a0d1d5-8cde-7220-a944-046c7b41be70", "title": "An introduction to filtered indexes", "url": "https://sqlsunday.com/2014/05/18/introduction-to-filtered-indexes/", "published_at": "2014-05-18T06:00:35+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce0ec73b9", "title": "Changes in Management Studio keyboard shortcuts", "url": "https://sqlsunday.com/2014/05/11/changes-in-ssms-keyboard-shortcuts/", "published_at": "2014-05-11T06:00:08+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce1a765e7", "title": "Late-arriving dimension members", "url": "https://sqlsunday.com/2014/05/04/late-arriving-members/", "published_at": "2014-05-04T06:00:09+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce25452bc", "title": "Minimally logged operations", "url": "https://sqlsunday.com/2014/04/27/minimally-logged-operations/", "published_at": "2014-04-27T06:00:46+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce297be38", "title": "Introduction to partitioning", "url": "https://sqlsunday.com/2014/04/20/introduction-to-partitioning/", "published_at": "2014-04-20T06:00:56+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce32d9452", "title": "Error handling using TRY-CATCH", "url": "https://sqlsunday.com/2014/04/13/error-handling-using-try-catch/", "published_at": "2014-04-13T06:00:30+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce34bd1c2", "title": "Accumulating values in a parent-child hierarchy", "url": "https://sqlsunday.com/2014/04/06/accumulating-in-a-hierarchy/", "published_at": "2014-04-06T06:00:08+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce385077e", "title": "An indented representation of a parent-child hierarchy", "url": "https://sqlsunday.com/2014/03/30/indented-parent-child-hierarchy/", "published_at": "2014-03-30T07:00:30+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce39c5bb7", "title": "Working with NULL values", "url": "https://sqlsunday.com/2014/03/23/null-values/", "published_at": "2014-03-23T07:00:56+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce412dcbf", "title": "Splitting a range string into a table", "url": "https://sqlsunday.com/2014/03/16/splitting-range-into-table/", "published_at": "2014-03-16T07:00:33+00:00" }, { "id": "01a0d1d5-b562-719f-976d-403ce4a1a0b6", "title": "Temp table myths", "url": "https://sqlsunday.com/2014/03/10/temp-table-myths/", "published_at": "2014-03-10T16:30:36+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882eba702341", "title": "Parsing parenthesis expressions", "url": "https://sqlsunday.com/2014/03/09/parsing-parenthesis-expressions/", "published_at": "2014-03-09T07:00:00+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebb0ac277", "title": "“Unpivot” using CROSS APPLY", "url": "https://sqlsunday.com/2014/03/02/unpivot-using-cross-apply/", "published_at": "2014-03-02T07:00:50+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebb0c788e", "title": "Cross-UPDATEs", "url": "https://sqlsunday.com/2014/02/23/cross-updates/", "published_at": "2014-02-23T07:00:22+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebba9dbfc", "title": "Calculating median using the NTILE function", "url": "https://sqlsunday.com/2014/02/16/calculating-median-using-ntile/", "published_at": "2014-02-16T07:00:36+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebc049b54", "title": "Aggregate string concatenations", "url": "https://sqlsunday.com/2014/02/09/aggregate-string-concatenations/", "published_at": "2014-02-09T07:00:59+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebd023974", "title": "The danger of scripting an Agent job", "url": "https://sqlsunday.com/2014/02/02/danger-of-scripting-a-job/", "published_at": "2014-02-02T07:00:58+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebd117030", "title": "Traversing parent-child relations", "url": "https://sqlsunday.com/2014/01/26/traversing-parent-child-relations/", "published_at": "2014-01-26T07:00:52+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebdf3e97e", "title": "SARGable expressions and performance", "url": "https://sqlsunday.com/2014/01/19/sargable-expression-performance/", "published_at": "2014-01-19T07:00:47+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebecd40ce", "title": "Calculating business days and holidays", "url": "https://sqlsunday.com/2014/01/12/business-days-and-holidays/", "published_at": "2014-01-12T07:00:30+00:00" }, { "id": "01a0d1d5-e081-720c-a9e7-882ebfa2eb44", "title": "About the spool operator", "url": "https://sqlsunday.com/2014/01/05/about-spool-operator/", "published_at": "2014-01-05T07:00:02+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f3b47dee", "title": "2014 is coming!", "url": "https://sqlsunday.com/2013/12/31/2014-is-coming/", "published_at": "2013-12-31T22:59:03+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f3ed2748", "title": "Rebuilding a transaction log file", "url": "https://sqlsunday.com/2013/12/29/rebuilding-a-transaction-log-file/", "published_at": "2013-12-29T07:00:43+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f4a60cf5", "title": "Efficient data, part 6: Versioning changes", "url": "https://sqlsunday.com/2013/12/22/efficient-data-part6-versioning/", "published_at": "2013-12-22T07:00:33+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f4debf58", "title": "Efficient data, part 5: Datatypes", "url": "https://sqlsunday.com/2013/12/15/efficient-data-part5-datatype-choices/", "published_at": "2013-12-15T07:00:33+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f5602d16", "title": "Efficient data, part 4: Fill factor", "url": "https://sqlsunday.com/2013/12/08/efficient-data-part4-fill-factor/", "published_at": "2013-12-08T07:00:33+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f5edc8bb", "title": "Efficient data, part 3: Compression", "url": "https://sqlsunday.com/2013/12/01/efficient-data-part3-compression/", "published_at": "2013-12-01T07:00:40+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f6cfea4f", "title": "Efficient data, part 2: Partitioning", "url": "https://sqlsunday.com/2013/11/24/efficient-data-part2-partitioning/", "published_at": "2013-11-24T07:00:53+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f75620f4", "title": "No explanation required.", "url": "https://sqlsunday.com/2013/11/18/no-explanation-required/", "published_at": "2013-11-18T08:51:55+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f7d9077e", "title": "Efficient data, part 1: Normalization", "url": "https://sqlsunday.com/2013/11/17/efficient-data-part1-normalization/", "published_at": "2013-11-17T07:00:06+00:00" }, { "id": "01a0d1d6-09f7-7148-a19b-cd09f8631b6f", "title": "Analyzing partition usage and skewing", "url": "https://sqlsunday.com/2013/11/10/analyzing-partitions/", "published_at": "2013-11-10T07:00:31+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d07c43012", "title": "Working with dependencies", "url": "https://sqlsunday.com/2013/11/03/working-with-dependencies/", "published_at": "2013-11-03T07:00:43+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d08a23cc7", "title": "Using DELETE on subqueries and common table expressions", "url": "https://sqlsunday.com/2013/10/27/delete-on-subqueries-and-ctes/", "published_at": "2013-10-27T06:00:23+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d08acb38b", "title": "SSMS: Useful custom keyboard shortcut", "url": "https://sqlsunday.com/2013/10/24/ssms-useful-custom-keyboard-shortcut/", "published_at": "2013-10-24T08:00:24+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d09921f86", "title": "Moving objects between schemas", "url": "https://sqlsunday.com/2013/10/20/moving-objects-between-schemas/", "published_at": "2013-10-20T06:00:28+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d09c86ca4", "title": "Instant file initialization", "url": "https://sqlsunday.com/2013/10/13/instant-file-initialization/", "published_at": "2013-10-13T06:00:41+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d09f3631e", "title": "Execution order of non-deterministic functions", "url": "https://sqlsunday.com/2013/10/06/exec-order-of-nondeterm-funcs/", "published_at": "2013-10-06T06:00:17+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d0ac009a5", "title": "The assert operator and different types of updates", "url": "https://sqlsunday.com/2013/09/29/assert-and-different-types-of-updates/", "published_at": "2013-09-29T06:00:58+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d0b8fe12f", "title": "Slowly changing dimensions (part 3)", "url": "https://sqlsunday.com/2013/09/22/introduction-to-scd-part-3/", "published_at": "2013-09-22T06:00:40+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d0bfe3826", "title": "Slowly changing dimensions (part 2)", "url": "https://sqlsunday.com/2013/09/15/introduction-to-scd-part-2/", "published_at": "2013-09-15T06:00:20+00:00" }, { "id": "01a0d1d6-2abd-703d-beb9-807d0c07316a", "title": "Slowly changing dimensions (part 1)", "url": "https://sqlsunday.com/2013/09/08/introduction-to-scd/", "published_at": "2013-09-08T06:00:43+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf857780c4", "title": "Using TOP n WITH TIES", "url": "https://sqlsunday.com/2013/09/01/using-top-n-with-ties/", "published_at": "2013-09-01T06:00:18+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf85928ffe", "title": "Creating a top-10 list and aggregating the remainder", "url": "https://sqlsunday.com/2013/08/25/top-10-and-aggregate-remainder/", "published_at": "2013-08-25T06:00:41+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf85be87f2", "title": "What you didn’t know about GO", "url": "https://sqlsunday.com/2013/08/18/go/", "published_at": "2013-08-18T06:00:34+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf86518f6f", "title": "Shrinking tempdb without restarting SQL Server", "url": "https://sqlsunday.com/2013/08/11/shrinking-tempdb-without-restarting-sql-server/", "published_at": "2013-08-11T06:00:48+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf86920ce8", "title": "Great article series on statistics", "url": "https://sqlsunday.com/2013/08/09/dale-burnett-on-statistics/", "published_at": "2013-08-09T12:10:16+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf8716b4cd", "title": "Cool MERGE features you may not know about", "url": "https://sqlsunday.com/2013/08/04/cool-merge-features/", "published_at": "2013-08-04T06:00:26+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf87937a19", "title": "Beginner’s guide to JOIN", "url": "https://sqlsunday.com/2013/07/28/beginners-guide-to-join/", "published_at": "2013-07-28T06:00:24+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf884ccfe7", "title": "Using NULLIF() to avoid division by zero", "url": "https://sqlsunday.com/2013/07/21/using-nullif-to-avoid-div-0/", "published_at": "2013-07-21T06:00:23+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf88f61a63", "title": "Using compression", "url": "https://sqlsunday.com/2013/07/14/using-compression/", "published_at": "2013-07-14T06:00:40+00:00" }, { "id": "01a0d1d6-4a15-72d2-b57f-18bf8902f24b", "title": "A function to calculate recurring dates", "url": "https://sqlsunday.com/2013/07/07/recurring-dates/", "published_at": "2013-07-07T06:00:47+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c585321958a2", "title": "Weeks and weekday parts in dates", "url": "https://sqlsunday.com/2013/06/30/weeks-weekdays/", "published_at": "2013-06-30T06:00:49+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853285b641", "title": "XML indexes", "url": "https://sqlsunday.com/2013/06/23/xml-indexes/", "published_at": "2013-06-23T06:00:42+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853317591b", "title": "Using DDL triggers to set up version control", "url": "https://sqlsunday.com/2013/06/16/using-ddl-triggers-to-set-up-version-control/", "published_at": "2013-06-16T06:00:05+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853388c6c0", "title": "Working with intervals", "url": "https://sqlsunday.com/2013/06/09/working-with-intervals/", "published_at": "2013-06-09T06:00:51+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c58534645d2d", "title": "A function to parse ranges", "url": "https://sqlsunday.com/2013/06/02/a-function-to-parse-ranges/", "published_at": "2013-06-02T06:00:09+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853533d1bb", "title": "Isolation levels", "url": "https://sqlsunday.com/2013/05/26/isolation-levels/", "published_at": "2013-05-26T06:00:51+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c58535d81213", "title": "Kerberos Configuration Manager for SQL Server", "url": "https://sqlsunday.com/2013/05/24/kerberos-configuration-manager-for-sql-server/", "published_at": "2013-05-24T20:58:54+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853646d838", "title": "An introduction to table types", "url": "https://sqlsunday.com/2013/05/19/table-types/", "published_at": "2013-05-19T06:00:48+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c58536d25ea8", "title": "Know your collation orders", "url": "https://sqlsunday.com/2013/05/19/know-your-collation-orders/", "published_at": "2013-05-19T06:00:04+00:00" }, { "id": "01a0d1d6-7243-71f8-ad8c-c5853754a73e", "title": "Converting JSON data to XML using a T-SQL function", "url": "https://sqlsunday.com/2013/05/12/converting-json-data-to-xml-using-a-t-sql-function/", "published_at": "2013-05-12T06:00:33+00:00" } ] posts Claim your blog
Back to sqlsunday.com
Blog · corpus.blog/blogs/sqlsunday.com/posts

sqlsunday.com

sqlsunday.com

2016

Windowed DISTINCT aggregatesoriginal ↗
26 Apr 2016
Last row per grouporiginal ↗
11 Apr 2016
Catching circular references in parent-child structuresoriginal ↗
4 Apr 2016
Different query plans for “OR” type queriesoriginal ↗
23 Mar 2016
Using UPDATE STATISTICS to fake row countsoriginal ↗
27 Feb 2016
Intermittent conversion issuesoriginal ↗
17 Feb 2016
Median and percentile in T-SQLoriginal ↗
11 Feb 2016
Migrating a database from Enterprise to Standard Edition?original ↗
6 Feb 2016
PIVOT, UNPIVOT and performanceoriginal ↗
28 Jan 2016

2015

The 2015 Swedish SQL Server usergroup challengeoriginal ↗
10 Dec 2015

2014

The 2014 Swedish SQL Server usergroup challengeoriginal ↗
11 Dec 2014
Segment and Sequence Projectoriginal ↗
7 Dec 2014
Joining two SCD2 tablesoriginal ↗
30 Nov 2014
Parallel execution, part 3original ↗
23 Nov 2014
Parallel execution, part 2original ↗
16 Nov 2014
Parallel execution, part 1original ↗
9 Nov 2014
Using memory optimized tables on VirtualBoxoriginal ↗
2 Nov 2014
Distributing values with overlapping rangesoriginal ↗
19 Oct 2014
Manual transaction managementoriginal ↗
12 Oct 2014
Viewing the size of your database objectsoriginal ↗
5 Oct 2014
User options and connection flagsoriginal ↗
28 Sept 2014
Identifiers in T-SQLoriginal ↗
21 Sept 2014
How to build a histogram in T-SQLoriginal ↗
14 Sept 2014
Using MERGE as a single INSERT or UPDATEoriginal ↗
7 Sept 2014
Partitioned views over table partitioningoriginal ↗
31 Aug 2014
Reloading fact tables with zero downtimeoriginal ↗
24 Aug 2014
Calculating 30/360 day count conventionoriginal ↗
17 Aug 2014
The SQL Server security model, part 4: execution contextoriginal ↗
10 Aug 2014
The SQL Server security model, part 3: permissionsoriginal ↗
3 Aug 2014
The SQL Server security model, part 2: securablesoriginal ↗
27 Jul 2014
The SQL Server security model, part 1: principalsoriginal ↗
20 Jul 2014
Building a calendar dimension with public holidaysoriginal ↗
13 Jul 2014
Calculating the date of easter sundayoriginal ↗
6 Jul 2014
Inline variable assignment in UPDATE statementsoriginal ↗
29 Jun 2014
Schemabinding and table spoolsoriginal ↗
22 Jun 2014
Blocking/non-blocking aggregate operatorsoriginal ↗
15 Jun 2014
Datawarehouse modelling: Inmon vs Kimballoriginal ↗
8 Jun 2014
HASH JOIN deep-diveoriginal ↗
1 Jun 2014
Directed acyclic graphs vs parent-child hierarchiesoriginal ↗
25 May 2014
An introduction to filtered indexesoriginal ↗
18 May 2014
Changes in Management Studio keyboard shortcutsoriginal ↗
11 May 2014
Late-arriving dimension membersoriginal ↗
4 May 2014
Minimally logged operationsoriginal ↗
27 Apr 2014
Introduction to partitioningoriginal ↗
20 Apr 2014
Error handling using TRY-CATCHoriginal ↗
13 Apr 2014
Accumulating values in a parent-child hierarchyoriginal ↗
6 Apr 2014
An indented representation of a parent-child hierarchyoriginal ↗
30 Mar 2014
Working with NULL valuesoriginal ↗
23 Mar 2014
Splitting a range string into a tableoriginal ↗
16 Mar 2014
Temp table mythsoriginal ↗
10 Mar 2014
Parsing parenthesis expressionsoriginal ↗
9 Mar 2014
“Unpivot” using CROSS APPLYoriginal ↗
2 Mar 2014
Cross-UPDATEsoriginal ↗
23 Feb 2014
Calculating median using the NTILE functionoriginal ↗
16 Feb 2014
Aggregate string concatenationsoriginal ↗
9 Feb 2014
The danger of scripting an Agent joboriginal ↗
2 Feb 2014
Traversing parent-child relationsoriginal ↗
26 Jan 2014
SARGable expressions and performanceoriginal ↗
19 Jan 2014
Calculating business days and holidaysoriginal ↗
12 Jan 2014
About the spool operatororiginal ↗
5 Jan 2014

2013

2014 is coming!original ↗
31 Dec 2013
Rebuilding a transaction log fileoriginal ↗
29 Dec 2013
Efficient data, part 6: Versioning changesoriginal ↗
22 Dec 2013
Efficient data, part 5: Datatypesoriginal ↗
15 Dec 2013
Efficient data, part 4: Fill factororiginal ↗
8 Dec 2013
Efficient data, part 3: Compressionoriginal ↗
1 Dec 2013
Efficient data, part 2: Partitioningoriginal ↗
24 Nov 2013
No explanation required.original ↗
18 Nov 2013
Efficient data, part 1: Normalizationoriginal ↗
17 Nov 2013
Analyzing partition usage and skewingoriginal ↗
10 Nov 2013
Working with dependenciesoriginal ↗
3 Nov 2013
Using DELETE on subqueries and common table expressionsoriginal ↗
27 Oct 2013
SSMS: Useful custom keyboard shortcutoriginal ↗
24 Oct 2013
Moving objects between schemasoriginal ↗
20 Oct 2013
Instant file initializationoriginal ↗
13 Oct 2013
Execution order of non-deterministic functionsoriginal ↗
6 Oct 2013
The assert operator and different types of updatesoriginal ↗
29 Sept 2013
Slowly changing dimensions (part 3)original ↗
22 Sept 2013
Slowly changing dimensions (part 2)original ↗
15 Sept 2013
Slowly changing dimensions (part 1)original ↗
8 Sept 2013
Using TOP n WITH TIESoriginal ↗
1 Sept 2013
Creating a top-10 list and aggregating the remainderoriginal ↗
25 Aug 2013
What you didn’t know about GOoriginal ↗
18 Aug 2013
Shrinking tempdb without restarting SQL Serveroriginal ↗
11 Aug 2013
Great article series on statisticsoriginal ↗
9 Aug 2013
Cool MERGE features you may not know aboutoriginal ↗
4 Aug 2013
Beginner’s guide to JOINoriginal ↗
28 Jul 2013
Using NULLIF() to avoid division by zerooriginal ↗
21 Jul 2013
Using compressionoriginal ↗
14 Jul 2013
A function to calculate recurring datesoriginal ↗
7 Jul 2013
Weeks and weekday parts in datesoriginal ↗
30 Jun 2013
XML indexesoriginal ↗
23 Jun 2013
Using DDL triggers to set up version controloriginal ↗
16 Jun 2013
Working with intervalsoriginal ↗
9 Jun 2013
A function to parse rangesoriginal ↗
2 Jun 2013
Isolation levelsoriginal ↗
26 May 2013
Kerberos Configuration Manager for SQL Serveroriginal ↗
24 May 2013
An introduction to table typesoriginal ↗
19 May 2013
Know your collation ordersoriginal ↗
19 May 2013
Converting JSON data to XML using a T-SQL functionoriginal ↗
12 May 2013
Previous Next