corpus.blog
41554 blogs · [ { "id": "01a087a5-09d0-72dd-a16e-c038eb4ac9d2", "title": "Partitioning a Huge Table Quickly", "url": "https://michaeljswart.com/2026/08/partitioning-a-huge-table-quickly/", "published_at": "2026-08-04T18:59:05+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ebef5b05", "title": "Partitioning a Huge Table", "url": "https://michaeljswart.com/2026/07/partitioning-a-huge-table/", "published_at": "2026-07-28T19:00:57+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ec35a262", "title": "Adding Foreign Keys Can Cause Deadlock Trouble", "url": "https://michaeljswart.com/2026/05/deadlock-trouble/", "published_at": "2026-05-20T15:12:52+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ec54c9ff", "title": "Read data from dropped columns", "url": "https://michaeljswart.com/2025/01/read-data-from-deleted-columns/", "published_at": "2025-01-06T21:44:51+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ecb0708a", "title": "Large Uniquifier Values", "url": "https://michaeljswart.com/2024/08/large-uniquifier-values/", "published_at": "2024-08-22T20:52:52+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ed77d852", "title": "Modeling Resource Governor Behavior", "url": "https://michaeljswart.com/2024/02/modeling-resource-governor-behavior/", "published_at": "2024-02-13T21:02:02+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ed874be5", "title": "A Quick SQL Server Puzzle About MIN_ACTIVE_ROWVERSION()", "url": "https://michaeljswart.com/2023/12/a-quick-sql-server-puzzle-about-min_active_rowversion/", "published_at": "2023-12-15T21:11:31+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038edb2b4e8", "title": "Watch Out For This Use Case When Using Read Committed Snapshot Isolation", "url": "https://michaeljswart.com/2023/10/watch-out-for-this-use-case-when-using-read-committed-snapshot-isolation/", "published_at": "2023-10-05T13:00:50+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038edc5a483", "title": "Deploying Resource Governor Using Online Scripts", "url": "https://michaeljswart.com/2023/08/deploying-resource-governor-using-online-scripts/", "published_at": "2023-08-16T16:07:08+00:00" }, { "id": "01a087a5-09d0-72dd-a16e-c038ee694349", "title": "Can your application handle all BIGINT values?", "url": "https://michaeljswart.com/2023/01/can-your-application-handle-all-bigint-values/", "published_at": "2023-01-03T17:24:28+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa019396818", "title": "Use RCSI to tackle most locking and blocking issues in SQL Server", "url": "https://michaeljswart.com/2022/11/use-rcsi-to-tackle-most-locking-and-blocking-issues-in-sql-server/", "published_at": "2022-11-25T17:54:52+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa019996551", "title": "You Can Specify Two Indexes In Table Hint?", "url": "https://michaeljswart.com/2022/10/you-can-specify-two-indexes-in-table-hint/", "published_at": "2022-10-12T16:00:09+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa019d5a11d", "title": "The Tyranny Of Cumulative Costs (Save and Forget Build Up)", "url": "https://michaeljswart.com/2022/10/the-tyranny-of-cumulative-costs-save-and-forget-build-up/", "published_at": "2022-10-06T16:00:25+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01ace0650", "title": "When are Non-Updating Updates Treated Like Regular Updates?", "url": "https://michaeljswart.com/2022/09/non-updates-are-still-updates/", "published_at": "2022-09-28T16:00:02+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01bb3c05d", "title": "Batching Follow-Up", "url": "https://michaeljswart.com/2022/09/batching-follow-up/", "published_at": "2022-09-21T16:00:10+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01c667d8e", "title": "The Effect of a Slow Registry on SQL Server", "url": "https://michaeljswart.com/2022/09/the-effect-of-a-slow-registry-on-sql-server/", "published_at": "2022-09-14T16:00:37+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01c7e8979", "title": "This Function Generates UNPIVOT Syntax", "url": "https://michaeljswart.com/2022/09/this-function-generates-unpivot-syntax/", "published_at": "2022-09-07T16:00:03+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01d24a29b", "title": "Formatting Binary(10) LSN Values For Use In sys.fn_dblog()", "url": "https://michaeljswart.com/2022/08/formatting-binary10-lsn-values-for-use-in-sys-fn_dblog/", "published_at": "2022-08-09T19:06:47+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01de73bd5", "title": "UPSERT Requires a Unique Index", "url": "https://michaeljswart.com/2022/03/upsert-requires-a-unique-index/", "published_at": "2022-03-18T14:11:17+00:00" }, { "id": "01a0bb93-abd0-7214-a8e6-2aa01ebf9ea9", "title": "Five Ways Time Makes Unit Tests Flaky", "url": "https://michaeljswart.com/2022/02/five-ways-time-makes-unit-tests-flaky/", "published_at": "2022-02-07T17:21:18+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf30fcfadd56", "title": "Measure the Effect of “Cost Threshold for Parallelism”", "url": "https://michaeljswart.com/2022/01/measure-the-effect-of-cost-threshold-for-parallelism/", "published_at": "2022-01-19T15:40:07+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf30fda33b27", "title": "A System-Maintained LastModifiedDate Column", "url": "https://michaeljswart.com/2021/10/a-system-maintained-lastmodifieddate-column/", "published_at": "2021-10-01T15:13:21+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf30fe184b87", "title": "Find Procedures That Use SELECT *", "url": "https://michaeljswart.com/2021/08/find-procedures-that-use-select/", "published_at": "2021-08-09T16:00:49+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf30ff077556", "title": "What To Avoid If You Want To Use MERGE", "url": "https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/", "published_at": "2021-08-04T17:06:39+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf30ff1d697d", "title": "Only UPDATE Rows That Are Changing, But Do It Carefully", "url": "https://michaeljswart.com/2021/04/only-update-rows-that-are-changing-but-do-it-carefully/", "published_at": "2021-04-01T16:20:24+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf310014e7ef", "title": "Avoid This Pitfall When Using sp_getapplock", "url": "https://michaeljswart.com/2021/01/avoid-this-pitfall-when-using-sp_getapplock/", "published_at": "2021-01-26T16:10:27+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf3100b10fd5", "title": "Pushing SQL Server Higher", "url": "https://michaeljswart.com/2021/01/pushing-sql-server-higher/", "published_at": "2021-01-18T14:39:01+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf3100b5793c", "title": "Collect Wait Stats Regularly in Order To Report On Them Over Time", "url": "https://michaeljswart.com/2021/01/collect-wait-stats-regularly-in-order-to-report-on-them-over-time/", "published_at": "2021-01-08T17:48:35+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf310149f5d3", "title": "Detect Excessive Spinlock Contention on SQL Server", "url": "https://michaeljswart.com/2020/10/detect-excessive-spinlock-contention-on-sql-server/", "published_at": "2020-10-28T17:36:02+00:00" }, { "id": "01a0bb9e-a74b-7132-acbb-bf310186a975", "title": "In Memory OLTP Defeated Our Tempdb Problems", "url": "https://michaeljswart.com/2020/10/in-memory-oltp-defeats-tempdb-problems/", "published_at": "2020-10-23T14:29:16+00:00" }, { "id": "01a0bba4-90bd-72dd-86af-1cc0c044cea7", "title": "How to Alter User Defined Table Types (Mostly) Online", "url": "https://michaeljswart.com/2020/10/how-to-alter-user-defined-table-types-mostly-online/", "published_at": "2020-10-19T18:41:37+00:00" }, { "id": "01a0bba4-90bd-72dd-86af-1cc0c052fb23", "title": "Maximum Simultaneous User Connections", "url": "https://michaeljswart.com/2020/10/maximum-simultaneous-user-connections/", "published_at": "2020-10-16T16:00:39+00:00" }, { "id": "01a0bba4-90bd-72dd-86af-1cc0c0b4bcb7", "title": "Monitoring Identity Columns for Room To Grow", "url": "https://michaeljswart.com/2020/07/monitoring-identity-columns-for-room-to-grow/", "published_at": "2020-07-17T16:01:41+00:00" }, { "id": "01a0bba4-90bd-72dd-86af-1cc0c0d69205", "title": "DROP TABLE Could Be Better", "url": "https://michaeljswart.com/2020/07/drop-table-could-be-better/", "published_at": "2020-07-10T15:05:51+00:00" }, { "id": "01a0bba4-90be-713e-9503-5264551a3e10", "title": "Problem Solving by Cheating", "url": "https://michaeljswart.com/2020/06/problem-solving-by-cheating/", "published_at": "2020-06-19T14:34:26+00:00" }, { "id": "01a0bba4-90be-713e-9503-52645521b057", "title": "Cross Database Transactions on One Server", "url": "https://michaeljswart.com/2020/05/cross_database_transactions/", "published_at": "2020-05-15T15:03:01+00:00" }, { "id": "01a0bba4-90be-713e-9503-526455966545", "title": "What Tables Are Being Written To The Most?", "url": "https://michaeljswart.com/2020/01/what-tables-are-being-written-to-the-most/", "published_at": "2020-01-28T15:38:23+00:00" }, { "id": "01a0bba4-90be-713e-9503-526455e98f22", "title": "Watching SQL Server Stuff From Performance Monitor", "url": "https://michaeljswart.com/2020/01/watching-sql-server-stuff-from-performance-monitor/", "published_at": "2020-01-20T21:41:00+00:00" }, { "id": "01a0bba4-90be-713e-9503-52645639d1ef", "title": "Finding Tables with Few Dependencies", "url": "https://michaeljswart.com/2019/04/finding-tables-with-few-dependencies/", "published_at": "2019-04-03T14:00:12+00:00" }, { "id": "01a0bba4-90be-713e-9503-526456fa5533", "title": "Lonely Tables in SQL Server", "url": "https://michaeljswart.com/2019/03/lonely-tables-in-sql-server/", "published_at": "2019-03-12T16:00:12+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bbe118de", "title": "Uncovering Hidden Complexity", "url": "https://michaeljswart.com/2018/10/uncovering-hidden-complexity/", "published_at": "2018-10-26T16:15:00+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bcc2054c", "title": "The Bare Minimum You Need To Know To Work With Git", "url": "https://michaeljswart.com/2018/07/the-bare-minimum-you-need-to-know-to-work-with-git/", "published_at": "2018-07-09T13:00:42+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bd207486", "title": "Shifting Gears in 2018", "url": "https://michaeljswart.com/2018/07/shifting-gears-in-2018/", "published_at": "2018-07-03T13:00:07+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bd4ef980", "title": "ORDER BY newid() is an Unbiased Way To Randomize", "url": "https://michaeljswart.com/2018/06/unbiased_newid/", "published_at": "2018-06-15T13:47:35+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bd9a29cd", "title": "Are There Any System Generated Constraint Names Lurking In Your Database?", "url": "https://michaeljswart.com/2018/04/are-there-any-system-generated-constraint-names-lurking-in-your-database/", "published_at": "2018-04-06T13:31:49+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9be7b4132", "title": "T-SQL Options for Comparing “Distinctness”", "url": "https://michaeljswart.com/2018/03/t-sql-options-for-comparing-distinctness/", "published_at": "2018-03-26T12:40:54+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bf42b6cf", "title": "“Failed to initialize deadlock control, Key cannot be null” When Viewing Deadlock Graphs", "url": "https://michaeljswart.com/2018/03/failed-to-initialize-deadlock-control-key-cannot-be-null-when-viewing-deadlock-graphs/", "published_at": "2018-03-15T14:02:17+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9bf6cac94", "title": "My Trip to the West Coast", "url": "https://michaeljswart.com/2018/03/my-trip-to-the-west-coast/", "published_at": "2018-03-12T15:22:45+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9c054bd4c", "title": "SHA1 Collisions in SQL Server", "url": "https://michaeljswart.com/2018/01/sha1-collisions-in-sql-server/", "published_at": "2018-01-17T13:00:19+00:00" }, { "id": "01a0bba9-c2a7-7385-a8b6-d7d9c1475e85", "title": "100 Percent Online Deployments: Stage and Switch", "url": "https://michaeljswart.com/2018/01/100-percent-online-deployments-stage-and-switch/", "published_at": "2018-01-15T17:42:46+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e0fef4267", "title": "100 Percent Online Deployments: Keep Changes OLTP-Friendly", "url": "https://michaeljswart.com/2018/01/100-percent-online-deployments-keep-changes-oltp-friendly/", "published_at": "2018-01-12T14:00:44+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e1000edc0", "title": "100 Percent Online Deployments: Blue Green Details", "url": "https://michaeljswart.com/2018/01/100-percent-online-deployments-blue-green-details/", "published_at": "2018-01-10T14:54:48+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e107a2c34", "title": "100 Percent Online Deployments: Blue-Green Deployment", "url": "https://michaeljswart.com/2018/01/100-percent-online-deployments-blue-green-deployment/", "published_at": "2018-01-08T17:06:46+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e10d53dd3", "title": "100% Online Deployments", "url": "https://michaeljswart.com/2018/01/100-online-deployments/", "published_at": "2018-01-05T15:01:28+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e10dfbfa9", "title": "When Measuring Timespans, try DATEADD instead of DATEDIFF", "url": "https://michaeljswart.com/2017/12/when-measuring-timespans-try-dateadd-instead-of-datediff/", "published_at": "2017-12-20T16:25:00+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e10e4cd8b", "title": "Postponing Our Use of In Memory OLTP", "url": "https://michaeljswart.com/2017/11/postponing-our-use-of-in-memory-oltp/", "published_at": "2017-11-10T14:30:23+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e11e0d196", "title": "Remove SQL Junk (Brackets and Other Clutter)", "url": "https://michaeljswart.com/2017/09/remove-sql-junk-brackets-and-other-clutter/", "published_at": "2017-09-11T14:42:43+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e12529b42", "title": "Problem With Too Many version_ghost_records", "url": "https://michaeljswart.com/2017/08/problem-with-too-many-version_ghost_records/", "published_at": "2017-08-02T12:00:15+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e1291ec7d", "title": "Solve this Math Puzzle using SQL", "url": "https://michaeljswart.com/2017/07/solve-this-math-puzzle-using-sql/", "published_at": "2017-07-24T13:08:40+00:00" }, { "id": "01a0bbae-c27e-71e4-a691-579e12d769d5", "title": "SQL Server UPSERT Patterns and Antipatterns", "url": "https://michaeljswart.com/2017/07/sql-server-upsert-patterns-and-antipatterns/", "published_at": "2017-07-20T15:34:13+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf5397706ae", "title": "10 Things I Learned While Working At D2L", "url": "https://michaeljswart.com/2017/07/10-things-i-learned-while-working-at-d2l/", "published_at": "2017-07-16T19:49:40+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53a287acf", "title": "Converting from DateTime to Ticks using SQL Server", "url": "https://michaeljswart.com/2017/07/converting-from-datetime-to-ticks-using-sql-server/", "published_at": "2017-07-06T13:55:08+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53b1de046", "title": "A Table Of Contents For the Data Industry", "url": "https://michaeljswart.com/2017/05/a-table-of-contents-for-the-data-industry/", "published_at": "2017-05-24T14:52:58+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53beb73f9", "title": "Drawing (again) with SQL Server", "url": "https://michaeljswart.com/2017/05/drawing-again-with-sql-server/", "published_at": "2017-05-05T14:41:01+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53ce5bca0", "title": "Find Your Dark Queries", "url": "https://michaeljswart.com/2017/04/finding-your-dark-queries/", "published_at": "2017-04-18T15:36:13+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53d181176", "title": "SQL vs. NoSQL", "url": "https://michaeljswart.com/2017/03/sql-vs-nosql/", "published_at": "2017-03-24T13:56:11+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53d3e44e2", "title": "A Program to Find INSERT Statements That Don’t Specify Columns", "url": "https://michaeljswart.com/2017/02/a-program-to-find-insert-statements-that-dont-specify-columns/", "published_at": "2017-02-22T13:00:55+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53d90cf0e", "title": "Generate Permutations Fast using SQL", "url": "https://michaeljswart.com/2017/02/generate-permutations-fast-using-sql/", "published_at": "2017-02-14T14:49:03+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53de99cf1", "title": "What Does “monitorLoop” mean in the Blocked Process Report", "url": "https://michaeljswart.com/2017/02/what-does-monitorloop-mean-in-the-blocked-process-report/", "published_at": "2017-02-10T14:11:25+00:00" }, { "id": "01a0bbb3-b18a-736b-9af8-2bf53e1dce0f", "title": "Case study: Troubleshooting Doomed Transactions", "url": "https://michaeljswart.com/2017/01/case-study-troubleshooting-doomed-transactions/", "published_at": "2017-01-16T13:00:45+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f24e2bb6", "title": "That Time We Fixed Prod Without Admin Credentials", "url": "https://michaeljswart.com/2016/12/that-time-we-fixed-prod-without-admin-credentials/", "published_at": "2016-12-22T14:00:35+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f3295fc5", "title": "Learn About SQL Server in the Waterloo Region", "url": "https://michaeljswart.com/2016/12/learn-about-sql-server-in-the-waterloo-region/", "published_at": "2016-12-01T14:34:03+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f3e9f021", "title": "I’m Sharing Some Cool Art Prints", "url": "https://michaeljswart.com/2016/11/im-sharing-some-cool-art-prints/", "published_at": "2016-11-22T13:00:22+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f4e1188c", "title": "Do You Have Check Constraints On Your Start and End Dates?", "url": "https://michaeljswart.com/2016/11/do-you-have-check-constraints-on-your-start-and-end-dates/", "published_at": "2016-11-21T15:13:17+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f57e9cb6", "title": "I’m Trying To Kick My “Undo Button” Habit", "url": "https://michaeljswart.com/2016/11/im-trying-to-kick-my-undo-button-habit/", "published_at": "2016-11-08T13:15:38+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f628f8b5", "title": "My 2016", "url": "https://michaeljswart.com/2016/10/my-2016/", "published_at": "2016-10-26T15:59:42+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f682184b", "title": "Build Your Own Tools", "url": "https://michaeljswart.com/2016/09/build-your-own-tools/", "published_at": "2016-09-23T12:37:58+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f6afb13b", "title": "Do you Use CLR in SQL Server?", "url": "https://michaeljswart.com/2016/07/do-you-use-clr-in-sql-server/", "published_at": "2016-07-27T15:11:45+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f6fbfe6d", "title": "Simplified Order Of Operations", "url": "https://michaeljswart.com/2016/07/simplified-order-of-operations/", "published_at": "2016-07-20T12:00:32+00:00" }, { "id": "01a0bbb9-37b0-721f-ac9b-a518f7f2bdae", "title": "PASS Summit 2016: Developing High Concurrency Databases", "url": "https://michaeljswart.com/2016/07/pass-summit-2016-developing-high-concurrency-databases/", "published_at": "2016-07-19T14:26:47+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe59be24c", "title": "Prioritize This List of Issues (Results)", "url": "https://michaeljswart.com/2016/07/prioritize-this-list-of-issues-results/", "published_at": "2016-07-07T12:00:54+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe5c695b1", "title": "Prioritize This List of Issues", "url": "https://michaeljswart.com/2016/07/prioritize-this-list-of-issues/", "published_at": "2016-07-05T13:14:22+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe5f659b1", "title": "T-SQL Tuesday #079 Roundup: It’s 2016!", "url": "https://michaeljswart.com/2016/06/t-sql-tuesday-079-roundup-its-2016/", "published_at": "2016-06-21T23:54:55+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe634ea8a", "title": "It’s 1966!", "url": "https://michaeljswart.com/2016/06/its-1966/", "published_at": "2016-06-14T02:56:40+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe6d6f327", "title": "T-SQL Tuesday #079: It’s 2016!", "url": "https://michaeljswart.com/2016/06/t-sql-tuesday-079-its-2016/", "published_at": "2016-06-07T01:41:23+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe7153df2", "title": "Some Thoughts On Logos", "url": "https://michaeljswart.com/2016/05/some-thoughts-on-logos/", "published_at": "2016-05-31T14:28:04+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe75873ea", "title": "One SSMS Improvement You Might Have Missed", "url": "https://michaeljswart.com/2016/05/one-ssms-improvement-you-might-have-missed/", "published_at": "2016-05-30T18:36:13+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe7fee1dc", "title": "You Can’t Force Query Plans If They Use TVPs With PKs", "url": "https://michaeljswart.com/2016/04/you-cant-force-query-plans-if-they-use-tvps-with-pks/", "published_at": "2016-04-27T16:24:26+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe89d575c", "title": "Are You Programming In The Database?", "url": "https://michaeljswart.com/2016/04/are-you-programming-in-the-database/", "published_at": "2016-04-20T18:11:59+00:00" }, { "id": "01a0bbbd-975b-7003-b3d3-07cbe9427280", "title": "Field and Record vs. Column and Table", "url": "https://michaeljswart.com/2016/04/field-and-record-vs-column-and-table/", "published_at": "2016-04-20T12:50:20+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d749bed7b", "title": "Tackle WRITELOG Waits Using the Transaction Log and Extended Events", "url": "https://michaeljswart.com/2016/04/tackle_writelog/", "published_at": "2016-04-11T17:11:21+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d74b9a93a", "title": "Microsoft Dropped the Cover Charge on SQL Server", "url": "https://michaeljswart.com/2016/04/no_cover_charge/", "published_at": "2016-04-01T12:00:56+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d7554092e", "title": "Microsoft Fixed My Biggest SQL Server Pet Peeve (Two Years Ago)", "url": "https://michaeljswart.com/2016/03/microsoft-fixed-my-biggest-sql-server-pet-peeve-two-years-ago/", "published_at": "2016-03-23T12:00:27+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d764370b4", "title": "Look at Blocked Process Reports Collected With Extended Events", "url": "https://michaeljswart.com/2016/02/look-at-blocked-process-reports-collected-with-extended-events/", "published_at": "2016-02-25T14:25:02+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d7714de1d", "title": "Future Proofing for Concurrency; Blocked Process Reports Are Not Enough", "url": "https://michaeljswart.com/2016/02/future-proofing-for-concurrency/", "published_at": "2016-02-17T13:00:33+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d77bddcdf", "title": "Ugly Pragmatism For The Win", "url": "https://michaeljswart.com/2016/02/ugly-pragmatism-for-the-win/", "published_at": "2016-02-11T16:37:43+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d77ee9825", "title": "You’re Probably Taking Sort Order For Granted Somewhere", "url": "https://michaeljswart.com/2016/02/youre-probably-taking-sort-order-for-granted-somewhere/", "published_at": "2016-02-03T13:00:26+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d78287e06", "title": "Sneaky Non-Determinism in Column Defaults", "url": "https://michaeljswart.com/2016/01/sneaky-non-determinism/", "published_at": "2016-01-27T13:00:29+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d78ac3282", "title": "Two Scripts That Help You Monitor Deadlocks with Extended Events", "url": "https://michaeljswart.com/2016/01/monitor_deadlocks/", "published_at": "2016-01-24T13:00:48+00:00" }, { "id": "01a0bbc2-2433-707b-9cf5-289d7963cdfb", "title": "Cursor Statistics Are Missing in dm_exec_query_stats", "url": "https://michaeljswart.com/2016/01/cursor-statistics-are-missing-in-dm_exec_query_stats/", "published_at": "2016-01-20T13:00:08+00:00" } ] posts Claim your blog
Back to michaeljswart.com
Blog · corpus.blog/blogs/michaeljswart.com/posts

michaeljswart.com

michaeljswart.com

2026

Partitioning a Huge Table Quicklyoriginal ↗
4 Aug 2026
Partitioning a Huge Tableoriginal ↗
28 Jul 2026
Adding Foreign Keys Can Cause Deadlock Troubleoriginal ↗
20 May 2026

2025

Read data from dropped columnsoriginal ↗
6 Jan 2025

2024

Large Uniquifier Valuesoriginal ↗
22 Aug 2024
Modeling Resource Governor Behaviororiginal ↗
13 Feb 2024

2023

A Quick SQL Server Puzzle About MIN_ACTIVE_ROWVERSION()original ↗
15 Dec 2023
Watch Out For This Use Case When Using Read Committed Snapshot Isolationoriginal ↗
5 Oct 2023
Deploying Resource Governor Using Online Scriptsoriginal ↗
16 Aug 2023
Can your application handle all BIGINT values?original ↗
3 Jan 2023

2022

Use RCSI to tackle most locking and blocking issues in SQL Serveroriginal ↗
25 Nov 2022
You Can Specify Two Indexes In Table Hint?original ↗
12 Oct 2022
The Tyranny Of Cumulative Costs (Save and Forget Build Up)original ↗
6 Oct 2022
When are Non-Updating Updates Treated Like Regular Updates?original ↗
28 Sept 2022
Batching Follow-Uporiginal ↗
21 Sept 2022
The Effect of a Slow Registry on SQL Serveroriginal ↗
14 Sept 2022
This Function Generates UNPIVOT Syntaxoriginal ↗
7 Sept 2022
Formatting Binary(10) LSN Values For Use In sys.fn_dblog()original ↗
9 Aug 2022
UPSERT Requires a Unique Indexoriginal ↗
18 Mar 2022
Five Ways Time Makes Unit Tests Flakyoriginal ↗
7 Feb 2022
Measure the Effect of “Cost Threshold for Parallelism”original ↗
19 Jan 2022

2021

A System-Maintained LastModifiedDate Columnoriginal ↗
1 Oct 2021
Find Procedures That Use SELECT *original ↗
9 Aug 2021
What To Avoid If You Want To Use MERGEoriginal ↗
4 Aug 2021
Only UPDATE Rows That Are Changing, But Do It Carefullyoriginal ↗
1 Apr 2021
Avoid This Pitfall When Using sp_getapplockoriginal ↗
26 Jan 2021
Pushing SQL Server Higheroriginal ↗
18 Jan 2021
Collect Wait Stats Regularly in Order To Report On Them Over Timeoriginal ↗
8 Jan 2021

2020

Detect Excessive Spinlock Contention on SQL Serveroriginal ↗
28 Oct 2020
In Memory OLTP Defeated Our Tempdb Problemsoriginal ↗
23 Oct 2020
How to Alter User Defined Table Types (Mostly) Onlineoriginal ↗
19 Oct 2020
Maximum Simultaneous User Connectionsoriginal ↗
16 Oct 2020
Monitoring Identity Columns for Room To Groworiginal ↗
17 Jul 2020
DROP TABLE Could Be Betteroriginal ↗
10 Jul 2020
Problem Solving by Cheatingoriginal ↗
19 Jun 2020
Cross Database Transactions on One Serveroriginal ↗
15 May 2020
What Tables Are Being Written To The Most?original ↗
28 Jan 2020
Watching SQL Server Stuff From Performance Monitororiginal ↗
20 Jan 2020

2019

Finding Tables with Few Dependenciesoriginal ↗
3 Apr 2019
Lonely Tables in SQL Serveroriginal ↗
12 Mar 2019

2018

Uncovering Hidden Complexityoriginal ↗
26 Oct 2018
The Bare Minimum You Need To Know To Work With Gitoriginal ↗
9 Jul 2018
Shifting Gears in 2018original ↗
3 Jul 2018
ORDER BY newid() is an Unbiased Way To Randomizeoriginal ↗
15 Jun 2018
Are There Any System Generated Constraint Names Lurking In Your Database?original ↗
6 Apr 2018
T-SQL Options for Comparing “Distinctness”original ↗
26 Mar 2018
“Failed to initialize deadlock control, Key cannot be null” When Viewing Deadlock Graphsoriginal ↗
15 Mar 2018
My Trip to the West Coastoriginal ↗
12 Mar 2018
SHA1 Collisions in SQL Serveroriginal ↗
17 Jan 2018
100 Percent Online Deployments: Stage and Switchoriginal ↗
15 Jan 2018
100 Percent Online Deployments: Keep Changes OLTP-Friendlyoriginal ↗
12 Jan 2018
100 Percent Online Deployments: Blue Green Detailsoriginal ↗
10 Jan 2018
100 Percent Online Deployments: Blue-Green Deploymentoriginal ↗
8 Jan 2018
100% Online Deploymentsoriginal ↗
5 Jan 2018

2017

When Measuring Timespans, try DATEADD instead of DATEDIFForiginal ↗
20 Dec 2017
Postponing Our Use of In Memory OLTPoriginal ↗
10 Nov 2017
Remove SQL Junk (Brackets and Other Clutter)original ↗
11 Sept 2017
Problem With Too Many version_ghost_recordsoriginal ↗
2 Aug 2017
Solve this Math Puzzle using SQLoriginal ↗
24 Jul 2017
SQL Server UPSERT Patterns and Antipatternsoriginal ↗
20 Jul 2017
10 Things I Learned While Working At D2Loriginal ↗
16 Jul 2017
Converting from DateTime to Ticks using SQL Serveroriginal ↗
6 Jul 2017
A Table Of Contents For the Data Industryoriginal ↗
24 May 2017
Drawing (again) with SQL Serveroriginal ↗
5 May 2017
Find Your Dark Queriesoriginal ↗
18 Apr 2017
SQL vs. NoSQLoriginal ↗
24 Mar 2017
A Program to Find INSERT Statements That Don’t Specify Columnsoriginal ↗
22 Feb 2017
Generate Permutations Fast using SQLoriginal ↗
14 Feb 2017
What Does “monitorLoop” mean in the Blocked Process Reportoriginal ↗
10 Feb 2017
Case study: Troubleshooting Doomed Transactionsoriginal ↗
16 Jan 2017

2016

That Time We Fixed Prod Without Admin Credentialsoriginal ↗
22 Dec 2016
Learn About SQL Server in the Waterloo Regionoriginal ↗
1 Dec 2016
I’m Sharing Some Cool Art Printsoriginal ↗
22 Nov 2016
Do You Have Check Constraints On Your Start and End Dates?original ↗
21 Nov 2016
I’m Trying To Kick My “Undo Button” Habitoriginal ↗
8 Nov 2016
My 2016original ↗
26 Oct 2016
Build Your Own Toolsoriginal ↗
23 Sept 2016
Do you Use CLR in SQL Server?original ↗
27 Jul 2016
Simplified Order Of Operationsoriginal ↗
20 Jul 2016
PASS Summit 2016: Developing High Concurrency Databasesoriginal ↗
19 Jul 2016
Prioritize This List of Issues (Results)original ↗
7 Jul 2016
Prioritize This List of Issuesoriginal ↗
5 Jul 2016
T-SQL Tuesday #079 Roundup: It’s 2016!original ↗
21 Jun 2016
It’s 1966!original ↗
14 Jun 2016
T-SQL Tuesday #079: It’s 2016!original ↗
7 Jun 2016
Some Thoughts On Logosoriginal ↗
31 May 2016
One SSMS Improvement You Might Have Missedoriginal ↗
30 May 2016
You Can’t Force Query Plans If They Use TVPs With PKsoriginal ↗
27 Apr 2016
Are You Programming In The Database?original ↗
20 Apr 2016
Field and Record vs. Column and Tableoriginal ↗
20 Apr 2016
Tackle WRITELOG Waits Using the Transaction Log and Extended Eventsoriginal ↗
11 Apr 2016
Microsoft Dropped the Cover Charge on SQL Serveroriginal ↗
1 Apr 2016
Microsoft Fixed My Biggest SQL Server Pet Peeve (Two Years Ago)original ↗
23 Mar 2016
Look at Blocked Process Reports Collected With Extended Eventsoriginal ↗
25 Feb 2016
Future Proofing for Concurrency; Blocked Process Reports Are Not Enoughoriginal ↗
17 Feb 2016
Ugly Pragmatism For The Winoriginal ↗
11 Feb 2016
You’re Probably Taking Sort Order For Granted Somewhereoriginal ↗
3 Feb 2016
Sneaky Non-Determinism in Column Defaultsoriginal ↗
27 Jan 2016
Two Scripts That Help You Monitor Deadlocks with Extended Eventsoriginal ↗
24 Jan 2016
Cursor Statistics Are Missing in dm_exec_query_statsoriginal ↗
20 Jan 2016
Next