corpus.blog
41554 blogs · [ { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdb87fd40", "title": "Understanding Memory Fractions", "url": "https://sqlserverfast.com/blog/hugo/2022/05/understanding-memory-fractions/", "published_at": "2022-05-18T17:30:21+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdc10caa3", "title": "More Execution Plan Video Training – pre-order now!", "url": "https://sqlserverfast.com/blog/hugo/2022/05/more-execution-plan-video-training-pre-order-now/", "published_at": "2022-05-11T13:07:07+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdc8b8bbf", "title": "T-SQL Tuesday #150 – My first technical job", "url": "https://sqlserverfast.com/blog/hugo/2022/05/t-sql-tuesday-150-my-first-technical-job/", "published_at": "2022-05-10T17:00:11+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdcec5573", "title": "Execution Plans in Azure Data Studio", "url": "https://sqlserverfast.com/blog/hugo/2022/03/execution-plans-in-azure-data-studio/", "published_at": "2022-03-09T12:42:53+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbddb21dc4", "title": "Breaking the silence", "url": "https://sqlserverfast.com/blog/hugo/2022/02/breaking-the-silence/", "published_at": "2022-02-09T15:00:28+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbde27a2d6", "title": "Here’s the execution plan … now what?", "url": "https://sqlserverfast.com/blog/hugo/2022/02/heres-the-execution-plan-now-what/", "published_at": "2022-02-08T17:00:24+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbde7039cf", "title": "Black Friday sale", "url": "https://sqlserverfast.com/blog/hugo/2021/10/black-friday-sale/", "published_at": "2021-10-26T10:32:14+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdecb8741", "title": "Recorded conference sessions", "url": "https://sqlserverfast.com/blog/hugo/2021/08/recorded-conference-sessions/", "published_at": "2021-08-23T13:43:19+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbdfc2dbc4", "title": "Plansplaining, part 19. Temporal tables (part 4)", "url": "https://sqlserverfast.com/blog/hugo/2021/07/plansplaining-part-19-temporal-tables-part-4/", "published_at": "2021-07-05T19:37:45+00:00" }, { "id": "01a0d1d4-f1d6-7226-ad06-bbdbe09db31c", "title": "T-SQL Tuesday #139 – Execution plans in a hybrid world", "url": "https://sqlserverfast.com/blog/hugo/2021/06/t-sql-tuesday-139-execution-plans-in-a-hybrid-world/", "published_at": "2021-06-08T15:00:02+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01ca7dc4578", "title": "Free video on percentages in execution plans", "url": "https://sqlserverfast.com/blog/hugo/2021/05/free-video-on-percentages-in-execution-plans/", "published_at": "2021-05-24T12:09:47+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01ca8b627c9", "title": "Plansplaining, part 18. Temporal tables (part 3)", "url": "https://sqlserverfast.com/blog/hugo/2021/05/plansplaining-part-18-temporal-tables-part-3/", "published_at": "2021-05-20T15:46:40+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01ca8ea8594", "title": "Recorded session: Debugging without debugger", "url": "https://sqlserverfast.com/blog/hugo/2021/05/recorded-session-debugging-without-debugger/", "published_at": "2021-05-12T09:10:25+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01ca9a98af6", "title": "T-SQL Tuesday #138 – Keeping up with change", "url": "https://sqlserverfast.com/blog/hugo/2021/05/t-sql-tuesday-138-keeping-up-with-change/", "published_at": "2021-05-11T10:00:42+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01ca9ac70fe", "title": "How a row goal affects estimates", "url": "https://sqlserverfast.com/blog/hugo/2021/04/how-a-row-goal-affects-estimates/", "published_at": "2021-04-30T16:07:07+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01caa5c3750", "title": "Execution plans – learning opportunities", "url": "https://sqlserverfast.com/blog/hugo/2021/04/execution-plans-learning-opportunities/", "published_at": "2021-04-25T14:03:53+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01caa8f97ee", "title": "Execution Plan Video Training – Announcing the next block", "url": "https://sqlserverfast.com/blog/hugo/2021/04/execution-plan-video-training-announcing-the-next-block/", "published_at": "2021-04-17T15:12:15+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01cab3bfcbc", "title": "T-SQL Tuesday #137 – Use notebooks every day? No way!", "url": "https://sqlserverfast.com/blog/hugo/2021/04/t-sql-tuesday-137-use-notebooks-every-day-no-way/", "published_at": "2021-04-13T15:00:56+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01cab921a52", "title": "Plansplaining, part 17. Temporal tables (part 2)", "url": "https://sqlserverfast.com/blog/hugo/2021/04/plansplaining-part-17-temporal-tables-part-2/", "published_at": "2021-04-06T14:00:38+00:00" }, { "id": "01a0d1d5-1af7-7330-8148-a01cabfa0e6a", "title": "T-SQL Tuesday #136 – Float does NOT suck!", "url": "https://sqlserverfast.com/blog/hugo/2021/03/9874/", "published_at": "2021-03-09T20:02:25+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67a7b1f841", "title": "Plansplaining, part 16. Temporal tables (part 1)", "url": "https://sqlserverfast.com/blog/hugo/2021/02/plansplaining-part-16-temporal-tables-part-1/", "published_at": "2021-02-24T18:31:44+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67a86f4216", "title": "T-SQL Tuesday #135 – My tools to stay alive", "url": "https://sqlserverfast.com/blog/hugo/2021/02/t-sql-tuesday-135-my-tools-to-stay-alive/", "published_at": "2021-02-09T15:00:21+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67a92a11e8", "title": "T-SQL Tuesday #134 – Give me a break!", "url": "https://sqlserverfast.com/blog/hugo/2021/01/t-sql-tuesday-134-give-me-a-break/", "published_at": "2021-01-12T15:00:41+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67a9cfb75d", "title": "Plansplaining, part 15. Foreign keys, part 4", "url": "https://sqlserverfast.com/blog/hugo/2021/01/plansplaining-part-15-foreign-keys-part-4/", "published_at": "2021-01-04T15:00:45+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67aa5a2f65", "title": "Plansplaining, part 14. Foreign keys, part 3", "url": "https://sqlserverfast.com/blog/hugo/2020/12/plansplaining-part-14-foreign-keys-part-3/", "published_at": "2020-12-19T18:54:27+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67ab3ec2b3", "title": "Plansplaining, part 13. Foreign keys, part 2", "url": "https://sqlserverfast.com/blog/hugo/2020/12/plansplaining-part-13-foreign-keys-part-2/", "published_at": "2020-12-07T14:59:33+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67abdf8277", "title": "Plansplaining, part 12. Foreign keys, part 1", "url": "https://sqlserverfast.com/blog/hugo/2020/11/plansplaining-part-12-foreign-keys-part-1/", "published_at": "2020-11-26T19:38:41+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67ac475786", "title": "PASS virtual summit: thoughts, pre-con, and sessions", "url": "https://sqlserverfast.com/blog/hugo/2020/10/pass-virtual-summit-thoughts-pre-con-and-sessions/", "published_at": "2020-10-17T16:36:00+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67acb52eb6", "title": "T-SQL Tuesday #131 – Join operators simplified", "url": "https://sqlserverfast.com/blog/hugo/2020/10/t-sql-tuesday-131-join-operators-simplified/", "published_at": "2020-10-13T15:00:43+00:00" }, { "id": "01a0d1d5-3d4f-7173-9b08-ac67ada0aad4", "title": "Plansplaining, part 11. Merge plans", "url": "https://sqlserverfast.com/blog/hugo/2020/09/plansplaining-part-11-merge-plans/", "published_at": "2020-09-30T15:29:12+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f82fd2c3ad", "title": "The SQLServerFast Execution Plan Video Training: an update", "url": "https://sqlserverfast.com/blog/hugo/2020/09/the-sqlserverfast-execution-plan-video-training-an-update/", "published_at": "2020-09-17T21:02:36+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f830711efe", "title": "T-SQL Tuesday #130 – Automated restores", "url": "https://sqlserverfast.com/blog/hugo/2020/09/t-sql-tuesday-120-automated-restores/", "published_at": "2020-09-08T15:00:54+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f830a4db2a", "title": "Estimated I/O cost, a sign of an expected spill", "url": "https://sqlserverfast.com/blog/hugo/2020/08/estimated-i-o-cost-a-sign-of-an-expected-spill/", "published_at": "2020-08-21T18:56:42+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f830eb9be7", "title": "T-SQL Tuesday #129 – Time capsule", "url": "https://sqlserverfast.com/blog/hugo/2020/08/t-sql-tuesday-129-time-capsule/", "published_at": "2020-08-11T14:00:20+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f831e4a33a", "title": "PASS Virtual Summit 2020", "url": "https://sqlserverfast.com/blog/hugo/2020/08/pass-virtual-summit-2020/", "published_at": "2020-08-04T20:26:56+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f831edd2de", "title": "Stop the “seeks are better than scans” myth, now!", "url": "https://sqlserverfast.com/blog/hugo/2020/07/stop-the-seeks-are-better-than-scans-myth-now/", "published_at": "2020-07-27T08:30:31+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f8327a28ff", "title": "T-SQL Tuesday #128 – My mistake", "url": "https://sqlserverfast.com/blog/hugo/2020/07/t-sql-tuesday-128-my-mistake/", "published_at": "2020-07-14T15:00:33+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f832fd5564", "title": "When the actual IO statistics seem wrong", "url": "https://sqlserverfast.com/blog/hugo/2020/06/when-the-actual-io-statistics-seem-wrong/", "published_at": "2020-06-26T18:55:38+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f833769adf", "title": "T-SQL Tuesday #127 – Non SQL tips and tricks", "url": "https://sqlserverfast.com/blog/hugo/2020/06/t-sql-tuesday-127-non-sql-tips-and-tricks/", "published_at": "2020-06-09T17:52:53+00:00" }, { "id": "01a0d1d5-5e55-7166-b2a9-e6f833f3e4a8", "title": "Actual I/O Statistics in the execution plan", "url": "https://sqlserverfast.com/blog/hugo/2020/06/actual-i-o-statistics-in-the-execution-plan/", "published_at": "2020-06-08T12:35:00+00:00" }, { "id": "01a0d1d5-7fb6-735b-bd6a-3687ddc6dd16", "title": "Row counts and arrow width, more missing nodes", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-more-missing-nodes/", "published_at": "2020-05-28T14:00:22+00:00" }, { "id": "01a0d1d5-7fb6-735b-bd6a-3687debe6e2f", "title": "Row counts and arrow width, Compute Scalar", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-compute-scalar/", "published_at": "2020-05-25T14:00:22+00:00" }, { "id": "01a0d1d5-7fb6-735b-bd6a-3687df4e96b9", "title": "Row counts and arrow width, missing nodes", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-missing-nodes/", "published_at": "2020-05-21T14:00:10+00:00" }, { "id": "01a0d1d5-7fb6-735b-bd6a-3687dfb12f9b", "title": "Row counts and arrow width, read or returned", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-read-or-returned/", "published_at": "2020-05-18T14:00:58+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe753e3ed19", "title": "Row counts and arrow width, ignoring execution count", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-ignoring-execution-count/", "published_at": "2020-05-14T14:00:42+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe7542d6cdc", "title": "T-SQL Tuesday #118 – My response to COVID-19", "url": "https://sqlserverfast.com/blog/hugo/2020/05/t-sql-tuesday-118-my-response-to-covid-19/", "published_at": "2020-05-12T19:38:19+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe7547a55c0", "title": "Row counts and arrow width, a primer", "url": "https://sqlserverfast.com/blog/hugo/2020/05/row-counts-and-arrow-width-a-primer/", "published_at": "2020-05-11T14:00:48+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe7548223f9", "title": "Query Store, force my plan on that other server too, please?", "url": "https://sqlserverfast.com/blog/hugo/2020/04/query-store-force-my-plan-on-that-other-server-too-please/", "published_at": "2020-04-22T17:13:53+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe7555f0d3c", "title": "SSMS 18.5 – small change, huge effect!", "url": "https://sqlserverfast.com/blog/hugo/2020/04/ssms-18-5-small-change-huge-effect/", "published_at": "2020-04-07T19:40:10+00:00" }, { "id": "01a0d1d5-7fb7-70c5-898f-5fe7558c6b3c", "title": "Announcing … the execution plan video training", "url": "https://sqlserverfast.com/blog/hugo/2020/04/announcing-the-execution-plan-video-training/", "published_at": "2020-04-02T19:01:30+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf599e086ce", "title": "Stop the name-calling! … Execution plan terminology", "url": "https://sqlserverfast.com/blog/hugo/2020/02/stop-the-name-calling-execution-plan-terminology/", "published_at": "2020-02-29T13:47:47+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59a67e2ff", "title": "No I can!", "url": "https://sqlserverfast.com/blog/hugo/2019/05/no-i-can/", "published_at": "2019-05-17T12:10:44+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59b3c0454", "title": "Removing multiple patterns from a string", "url": "https://sqlserverfast.com/blog/hugo/2019/04/removing-multiple-patterns-from-a-string/", "published_at": "2019-04-20T10:54:43+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59c0e662c", "title": "T-SQL Tuesday #111: Why, tell me why", "url": "https://sqlserverfast.com/blog/hugo/2019/02/t-sql-tuesday-111-why-tell-me-why/", "published_at": "2019-02-12T15:00:45+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59c25fa69", "title": "Plansplaining, part 10. Just passing through", "url": "https://sqlserverfast.com/blog/hugo/2019/02/plansplaining-part-10-just-passing-through/", "published_at": "2019-02-04T17:58:11+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59c42216b", "title": "SQL injection", "url": "https://sqlserverfast.com/blog/hugo/2019/02/sql-injection/", "published_at": "2019-02-02T17:14:03+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59cf42a08", "title": "Collation change script", "url": "https://sqlserverfast.com/blog/hugo/2019/01/collation-change-script/", "published_at": "2019-01-21T19:00:53+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59dacfea3", "title": "Off Topic: Charity and snooker", "url": "https://sqlserverfast.com/blog/hugo/2019/01/off-topic-charity-and-snooker/", "published_at": "2019-01-17T21:54:32+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59eaafd42", "title": "T-SQL Tuesday #110 – “Automate All the Things”", "url": "https://sqlserverfast.com/blog/hugo/2019/01/t-sql-tuesday-110-automate-all-the-things/", "published_at": "2019-01-08T11:52:57+00:00" }, { "id": "01a0d1d5-9ebc-7028-9784-bdf59f9f2372", "title": "Looking back to 2018", "url": "https://sqlserverfast.com/blog/hugo/2018/12/looking-back-to-2018/", "published_at": "2018-12-31T15:48:58+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192261b1be0c", "title": "Plansplaining, part 9. Recursive CTEs", "url": "https://sqlserverfast.com/blog/hugo/2018/12/plansplaining-part-9-recursive-ctes/", "published_at": "2018-12-03T16:00:37+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-1922625a218f", "title": "More information in execution plans", "url": "https://sqlserverfast.com/blog/hugo/2018/11/more-information-in-execution-plans/", "published_at": "2018-11-12T20:18:09+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192263560a15", "title": "T-SQL Tuesday #106: How to use triggers and not be sad", "url": "https://sqlserverfast.com/blog/hugo/2018/09/t-sql-tuesday-106-how-to-use-triggers-and-not-be-sad/", "published_at": "2018-09-11T20:03:31+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192263abcb4e", "title": "The best execution plan book ever written", "url": "https://sqlserverfast.com/blog/hugo/2018/09/the-best-execution-plan-book-ever-written/", "published_at": "2018-09-10T18:05:19+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192264688309", "title": "T-SQL Tuesday #105: Brick walls", "url": "https://sqlserverfast.com/blog/hugo/2018/08/t-sql-tuesday-105-brick-walls/", "published_at": "2018-08-14T15:00:49+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192264db7606", "title": "Plansplaining, part 8. To join the impossible join", "url": "https://sqlserverfast.com/blog/hugo/2018/08/plansplaining-part-8-to-join-the-impossible-join/", "published_at": "2018-08-06T15:00:51+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-19226544cddb", "title": "My thoughts on session levels", "url": "https://sqlserverfast.com/blog/hugo/2018/07/my-thoughts-on-session-levels/", "published_at": "2018-07-25T15:18:29+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192265c445d3", "title": "T-SQL Tuesday #104: Make Ola backup BizTalk", "url": "https://sqlserverfast.com/blog/hugo/2018/07/t-sql-tuesday-104-make-ola-backup-biztalk/", "published_at": "2018-07-10T12:52:41+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-1922666314d0", "title": "T-SQL Tuesday #104 (part 1): sp_metasearch", "url": "https://sqlserverfast.com/blog/hugo/2018/07/t-sql-tuesday-104-part-1-sp_metasearch/", "published_at": "2018-07-10T11:45:48+00:00" }, { "id": "01a0d1d5-c9f2-729f-b94c-192266b93195", "title": "Plansplaining, part 7. The Constant Scan that returns no data", "url": "https://sqlserverfast.com/blog/hugo/2018/07/plansplaining-part-7-the-constant-scan-that-returns-no-data/", "published_at": "2018-07-02T15:00:38+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0faacae5f8", "title": "Plansplaining, part 6. Aggregates with OVER.", "url": "https://sqlserverfast.com/blog/hugo/2018/06/plansplaining-part-6-aggregates-with-over/", "published_at": "2018-06-04T15:00:11+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fab735a80", "title": "Announcing: The SQL Server Execution Plan Reference", "url": "https://sqlserverfast.com/blog/hugo/2018/05/announcing-the-sql-server-execution-plan-reference/", "published_at": "2018-05-31T19:09:56+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fac606b19", "title": "T-SQL Tuesday #102: Announcing a new site", "url": "https://sqlserverfast.com/blog/hugo/2018/05/t-sql-tuesday-102-announcing-a-new-site/", "published_at": "2018-05-08T16:00:19+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0facc19593", "title": "Plansplaining, part 5. Bitmaps", "url": "https://sqlserverfast.com/blog/hugo/2018/05/plansplaining-part-5-bitmaps/", "published_at": "2018-05-07T15:00:55+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fad429d64", "title": "The Segment operator, an error in Books Online", "url": "https://sqlserverfast.com/blog/hugo/2018/04/the-segment-operator-an-error-in-books-online/", "published_at": "2018-04-22T21:21:15+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fae3692e0", "title": "T-SQL Tuesday #101: A few of my favorite tools", "url": "https://sqlserverfast.com/blog/hugo/2018/04/t-sql-tuesday-101-a-few-of-my-favorite-tools/", "published_at": "2018-04-10T22:23:06+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0faef43514", "title": "Plansplaining, part 4. Let’s repartition the streams.", "url": "https://sqlserverfast.com/blog/hugo/2018/04/plansplaining-part-4-lets-repartition-the-streams/", "published_at": "2018-04-02T15:00:41+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fafde64e8", "title": "T-SQL Tuesday #100: Looking forward", "url": "https://sqlserverfast.com/blog/hugo/2018/03/t-sql-tuesday-100-looking-forward/", "published_at": "2018-03-13T15:00:09+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fb0126c8a", "title": "Plansplaining, part 3. How repeating work saves time", "url": "https://sqlserverfast.com/blog/hugo/2018/03/plansplaining-part-3-repeating-work-saves-time/", "published_at": "2018-03-05T16:00:22+00:00" }, { "id": "01a0d1d5-f7cb-7385-b5c1-cb0fb0e24ae9", "title": "SSMS hidden gem: Edit Query Text", "url": "https://sqlserverfast.com/blog/hugo/2018/03/ssms-hidden-gem-edit-query-text/", "published_at": "2018-03-03T13:33:35+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e376d0c88c", "title": "Execution plans 101: (back to) The basics", "url": "https://sqlserverfast.com/blog/hugo/2018/02/execution-plans-101-back-basics/", "published_at": "2018-02-24T16:46:23+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e376d5343b", "title": "T-SQL Tuesday #99: Dealer’s Choice", "url": "https://sqlserverfast.com/blog/hugo/2018/02/t-sql-tuesday-99-dealers-choice/", "published_at": "2018-02-13T20:00:33+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e377829d80", "title": "Plansplaining, part 2. Why scan and spool instead of seek?", "url": "https://sqlserverfast.com/blog/hugo/2018/02/plansplaining-part-2-scan-spool-instead-seek/", "published_at": "2018-02-05T16:00:37+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e37880cbac", "title": "Plansplaining, part 1. The unexpected aggregation and assert", "url": "https://sqlserverfast.com/blog/hugo/2018/01/plansplaining-part-1-unexpected-aggregation-assert/", "published_at": "2018-01-08T16:50:30+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e3793f233d", "title": "The many (too many?) reads of a many to many Merge Join", "url": "https://sqlserverfast.com/blog/hugo/2017/12/many-many-reads-many-many-merge-join/", "published_at": "2017-12-24T11:53:14+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e3799c49d8", "title": "Willkommen, Bienvenue, Welcome", "url": "https://sqlserverfast.com/blog/hugo/2017/12/willkommen-bienvenue-welcome/", "published_at": "2017-12-14T23:45:39+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e37a8a98e4", "title": "Three new sessions in three months", "url": "https://sqlserverfast.com/blog/hugo/2017/09/three-new-sessions-in-three-months/", "published_at": "2017-09-14T22:07:18+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e37b50e398", "title": "Misconceptions on parameter sniffing", "url": "https://sqlserverfast.com/blog/hugo/2016/11/misconceptions-on-parameter-sniffing/", "published_at": "2016-11-03T01:55:00+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e37b97199d", "title": "The sniffing database", "url": "https://sqlserverfast.com/blog/hugo/2016/10/the-sniffing-database/", "published_at": "2016-10-23T23:28:00+00:00" }, { "id": "01a0d1d6-18d2-71f9-b72d-98e37beb2b50", "title": "Upcoming presentations. And an offer.", "url": "https://sqlserverfast.com/blog/hugo/2016/09/upcoming-presentations-and-an-offer/", "published_at": "2016-09-15T23:39:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8cc78f00", "title": "The DIY guide for local-global aggregation", "url": "https://sqlserverfast.com/blog/hugo/2016/08/the-diy-guide-for-local-global-aggregation/", "published_at": "2016-08-31T23:08:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8d01979d", "title": "How TOP wrecks performance (part 2)", "url": "https://sqlserverfast.com/blog/hugo/2016/06/how-top-wrecks-performance-part-2/", "published_at": "2016-06-25T23:22:58+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8d889c59", "title": "How TOP wrecks performance (part 1)", "url": "https://sqlserverfast.com/blog/hugo/2014/11/how-top-wrecks-performance-part-1/", "published_at": "2014-11-06T17:51:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8ded9417", "title": "Give speakers feedback. It makes a difference.", "url": "https://sqlserverfast.com/blog/hugo/2014/10/give-speakers-feedback-it-makes-a-difference/", "published_at": "2014-10-25T23:19:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8eda8ebb", "title": "Execution plans, laundry, and a giveaway", "url": "https://sqlserverfast.com/blog/hugo/2014/10/execution-plans-laundry-and-a-giveaway/", "published_at": "2014-10-25T00:57:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8f1b7f4a", "title": "Database Mail … and then the SMTP Server changed", "url": "https://sqlserverfast.com/blog/hugo/2014/07/database-mail-and-then-the-smtp-server-changed/", "published_at": "2014-07-18T23:30:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8f5aa91d", "title": "PASS Summit Abstract Feedback", "url": "https://sqlserverfast.com/blog/hugo/2014/07/pass-summit-abstract-feedback/", "published_at": "2014-07-12T00:53:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf8f5b652b", "title": "SQLPass NomCom election: Why I voted twice", "url": "https://sqlserverfast.com/blog/hugo/2014/06/sqlpass-nomcom-election-why-i-voted-twice/", "published_at": "2014-06-04T13:58:27+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf9037537f", "title": "SQL TuneIn Zagreb 2014 – Session material", "url": "https://sqlserverfast.com/blog/hugo/2014/06/sql-tunein-zagreb-2014-session-material/", "published_at": "2014-06-04T12:33:00+00:00" }, { "id": "01a0d1d6-3685-7393-8f61-b6bf90cdc413", "title": "TechDays 2014 – Session material", "url": "https://sqlserverfast.com/blog/hugo/2014/04/techdays-2014-session-material/", "published_at": "2014-04-23T00:34:00+00:00" } ] posts Claim your blog
Back to sqlserverfast.com
Blog · corpus.blog/blogs/sqlserverfast.com/posts

sqlserverfast.com

sqlserverfast.com

2022

Understanding Memory Fractionsoriginal ↗
18 May 2022
More Execution Plan Video Training – pre-order now!original ↗
11 May 2022
T-SQL Tuesday #150 – My first technical joboriginal ↗
10 May 2022
Execution Plans in Azure Data Studiooriginal ↗
9 Mar 2022
Breaking the silenceoriginal ↗
9 Feb 2022
Here’s the execution plan … now what?original ↗
8 Feb 2022

2021

Black Friday saleoriginal ↗
26 Oct 2021
Recorded conference sessionsoriginal ↗
23 Aug 2021
Plansplaining, part 19. Temporal tables (part 4)original ↗
5 Jul 2021
T-SQL Tuesday #139 – Execution plans in a hybrid worldoriginal ↗
8 Jun 2021
Free video on percentages in execution plansoriginal ↗
24 May 2021
Plansplaining, part 18. Temporal tables (part 3)original ↗
20 May 2021
Recorded session: Debugging without debuggeroriginal ↗
12 May 2021
T-SQL Tuesday #138 – Keeping up with changeoriginal ↗
11 May 2021
How a row goal affects estimatesoriginal ↗
30 Apr 2021
Execution plans – learning opportunitiesoriginal ↗
25 Apr 2021
Execution Plan Video Training – Announcing the next blockoriginal ↗
17 Apr 2021
T-SQL Tuesday #137 – Use notebooks every day? No way!original ↗
13 Apr 2021
Plansplaining, part 17. Temporal tables (part 2)original ↗
6 Apr 2021
T-SQL Tuesday #136 – Float does NOT suck!original ↗
9 Mar 2021
Plansplaining, part 16. Temporal tables (part 1)original ↗
24 Feb 2021
T-SQL Tuesday #135 – My tools to stay aliveoriginal ↗
9 Feb 2021
T-SQL Tuesday #134 – Give me a break!original ↗
12 Jan 2021
Plansplaining, part 15. Foreign keys, part 4original ↗
4 Jan 2021

2020

Plansplaining, part 14. Foreign keys, part 3original ↗
19 Dec 2020
Plansplaining, part 13. Foreign keys, part 2original ↗
7 Dec 2020
Plansplaining, part 12. Foreign keys, part 1original ↗
26 Nov 2020
PASS virtual summit: thoughts, pre-con, and sessionsoriginal ↗
17 Oct 2020
T-SQL Tuesday #131 – Join operators simplifiedoriginal ↗
13 Oct 2020
Plansplaining, part 11. Merge plansoriginal ↗
30 Sept 2020
The SQLServerFast Execution Plan Video Training: an updateoriginal ↗
17 Sept 2020
T-SQL Tuesday #130 – Automated restoresoriginal ↗
8 Sept 2020
Estimated I/O cost, a sign of an expected spilloriginal ↗
21 Aug 2020
T-SQL Tuesday #129 – Time capsuleoriginal ↗
11 Aug 2020
PASS Virtual Summit 2020original ↗
4 Aug 2020
Stop the “seeks are better than scans” myth, now!original ↗
27 Jul 2020
T-SQL Tuesday #128 – My mistakeoriginal ↗
14 Jul 2020
When the actual IO statistics seem wrongoriginal ↗
26 Jun 2020
T-SQL Tuesday #127 – Non SQL tips and tricksoriginal ↗
9 Jun 2020
Actual I/O Statistics in the execution planoriginal ↗
8 Jun 2020
Row counts and arrow width, more missing nodesoriginal ↗
28 May 2020
Row counts and arrow width, Compute Scalaroriginal ↗
25 May 2020
Row counts and arrow width, missing nodesoriginal ↗
21 May 2020
Row counts and arrow width, read or returnedoriginal ↗
18 May 2020
Row counts and arrow width, ignoring execution countoriginal ↗
14 May 2020
T-SQL Tuesday #118 – My response to COVID-19original ↗
12 May 2020
Row counts and arrow width, a primeroriginal ↗
11 May 2020
Query Store, force my plan on that other server too, please?original ↗
22 Apr 2020
SSMS 18.5 – small change, huge effect!original ↗
7 Apr 2020
Announcing … the execution plan video trainingoriginal ↗
2 Apr 2020
Stop the name-calling! … Execution plan terminologyoriginal ↗
29 Feb 2020

2019

No I can!original ↗
17 May 2019
Removing multiple patterns from a stringoriginal ↗
20 Apr 2019
T-SQL Tuesday #111: Why, tell me whyoriginal ↗
12 Feb 2019
Plansplaining, part 10. Just passing throughoriginal ↗
4 Feb 2019
SQL injectionoriginal ↗
2 Feb 2019
Collation change scriptoriginal ↗
21 Jan 2019
Off Topic: Charity and snookeroriginal ↗
17 Jan 2019
T-SQL Tuesday #110 – “Automate All the Things”original ↗
8 Jan 2019

2018

Looking back to 2018original ↗
31 Dec 2018
Plansplaining, part 9. Recursive CTEsoriginal ↗
3 Dec 2018
More information in execution plansoriginal ↗
12 Nov 2018
T-SQL Tuesday #106: How to use triggers and not be sadoriginal ↗
11 Sept 2018
The best execution plan book ever writtenoriginal ↗
10 Sept 2018
T-SQL Tuesday #105: Brick wallsoriginal ↗
14 Aug 2018
Plansplaining, part 8. To join the impossible joinoriginal ↗
6 Aug 2018
My thoughts on session levelsoriginal ↗
25 Jul 2018
T-SQL Tuesday #104: Make Ola backup BizTalkoriginal ↗
10 Jul 2018
T-SQL Tuesday #104 (part 1): sp_metasearchoriginal ↗
10 Jul 2018
Plansplaining, part 7. The Constant Scan that returns no dataoriginal ↗
2 Jul 2018
Plansplaining, part 6. Aggregates with OVER.original ↗
4 Jun 2018
Announcing: The SQL Server Execution Plan Referenceoriginal ↗
31 May 2018
T-SQL Tuesday #102: Announcing a new siteoriginal ↗
8 May 2018
Plansplaining, part 5. Bitmapsoriginal ↗
7 May 2018
The Segment operator, an error in Books Onlineoriginal ↗
22 Apr 2018
T-SQL Tuesday #101: A few of my favorite toolsoriginal ↗
10 Apr 2018
Plansplaining, part 4. Let’s repartition the streams.original ↗
2 Apr 2018
T-SQL Tuesday #100: Looking forwardoriginal ↗
13 Mar 2018
Plansplaining, part 3. How repeating work saves timeoriginal ↗
5 Mar 2018
SSMS hidden gem: Edit Query Textoriginal ↗
3 Mar 2018
Execution plans 101: (back to) The basicsoriginal ↗
24 Feb 2018
T-SQL Tuesday #99: Dealer’s Choiceoriginal ↗
13 Feb 2018
Plansplaining, part 2. Why scan and spool instead of seek?original ↗
5 Feb 2018
Plansplaining, part 1. The unexpected aggregation and assertoriginal ↗
8 Jan 2018

2017

The many (too many?) reads of a many to many Merge Joinoriginal ↗
24 Dec 2017
Willkommen, Bienvenue, Welcomeoriginal ↗
14 Dec 2017
Three new sessions in three monthsoriginal ↗
14 Sept 2017

2016

Misconceptions on parameter sniffingoriginal ↗
3 Nov 2016
The sniffing databaseoriginal ↗
23 Oct 2016
Upcoming presentations. And an offer.original ↗
15 Sept 2016
The DIY guide for local-global aggregationoriginal ↗
31 Aug 2016
How TOP wrecks performance (part 2)original ↗
25 Jun 2016

2014

How TOP wrecks performance (part 1)original ↗
6 Nov 2014
Give speakers feedback. It makes a difference.original ↗
25 Oct 2014
Execution plans, laundry, and a giveawayoriginal ↗
25 Oct 2014
Database Mail … and then the SMTP Server changedoriginal ↗
18 Jul 2014
PASS Summit Abstract Feedbackoriginal ↗
12 Jul 2014
SQLPass NomCom election: Why I voted twiceoriginal ↗
4 Jun 2014
SQL TuneIn Zagreb 2014 – Session materialoriginal ↗
4 Jun 2014
TechDays 2014 – Session materialoriginal ↗
23 Apr 2014
Previous Next