41554 blogs · [ { "id": "01a0bbc9-2ddd-7356-88e0-6fb089efe928", "title": "My Work Autobiography", "url": "https://michaeljswart.com/2016/01/my-work-autobiography/", "published_at": "2016-01-13T13:00:28+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08ad71428", "title": "Some Changes for 2016", "url": "https://michaeljswart.com/2016/01/some-changes-for-2016/", "published_at": "2016-01-06T13:00:23+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08bad335e", "title": "Don’t Abandon Your Transactions", "url": "https://michaeljswart.com/2015/10/dont-abandon-your-transactions/", "published_at": "2015-10-06T15:59:58+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08c29372b", "title": "Code Review This Procedure", "url": "https://michaeljswart.com/2015/10/code-review-this-procedure/", "published_at": "2015-10-01T14:28:03+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08c7142b8", "title": "Troubleshooting Tempdb, a Case Study", "url": "https://michaeljswart.com/2015/09/troubleshooting_tempdb/", "published_at": "2015-09-15T15:15:19+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08d326f78", "title": "Avoid Frequent use of TVPs With Wide Rows", "url": "https://michaeljswart.com/2015/08/avoid-frequent-use-of-tvps-with-wide-rows/", "published_at": "2015-08-31T12:00:09+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08e206bc6", "title": "What’s Going On Inside Tempdb?", "url": "https://michaeljswart.com/2015/08/whats_going_on_inside_tempdb/", "published_at": "2015-08-12T15:56:25+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08e847acd", "title": "Types of Performance Metrics", "url": "https://michaeljswart.com/2015/08/types-of-performance-metrics/", "published_at": "2015-08-05T13:00:49+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb08f732513", "title": "How to Create Indexed Views Online", "url": "https://michaeljswart.com/2015/06/how-to-create-indexed-views-online/", "published_at": "2015-06-24T12:00:53+00:00" }, { "id": "01a0bbc9-2ddd-7356-88e0-6fb09010dd95", "title": "It’s Hard To Destroy Data", "url": "https://michaeljswart.com/2015/05/its-hard-to-destroy-data/", "published_at": "2015-05-20T12:00:30+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c8765a1d34", "title": "The Appeal Of Lightning Talks", "url": "https://michaeljswart.com/2015/04/the-appeal-of-lightning-talks/", "published_at": "2015-04-27T15:32:23+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c876e5c5b9", "title": "Finding Scalar Aggregate Indexed Views in Your Database", "url": "https://michaeljswart.com/2015/04/finding-scalar-aggregate-indexed-views-in-your-database/", "published_at": "2015-04-06T14:35:07+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87750588f", "title": "Look at Blocking By Index", "url": "https://michaeljswart.com/2015/04/blocking_by_index/", "published_at": "2015-04-02T14:33:33+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87808b5bb", "title": "Some Tweets I Drew", "url": "https://michaeljswart.com/2015/04/some_tweets_i_drew/", "published_at": "2015-04-01T12:00:15+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c878f93a7d", "title": "Swart Draws Your Tweets", "url": "https://michaeljswart.com/2015/03/swart-draws-your-tweets/", "published_at": "2015-03-18T15:22:06+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c879a7e7e0", "title": "When Parameter Sniffing Caused Deadlocks", "url": "https://michaeljswart.com/2015/02/when-parameter-sniffing-caused-deadlocks/", "published_at": "2015-02-26T15:06:46+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87a8cd3f7", "title": "Designing Indexed Views for OLTP Workloads", "url": "https://michaeljswart.com/2015/01/designing-indexed-views-for-oltp-workloads/", "published_at": "2015-01-23T13:00:55+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87b78134b", "title": "Obvious and Not-So-Obvious Writing Tips", "url": "https://michaeljswart.com/2014/12/obvious-and-not-so-obvious-writing-tips/", "published_at": "2014-12-12T15:54:38+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87c2bd5e8", "title": "Materialized Views in SQL Server", "url": "https://michaeljswart.com/2014/12/materialized-views-in-sql-server/", "published_at": "2014-12-03T14:28:00+00:00" }, { "id": "01a0bbcd-dc63-7386-af77-b8c87d141d22", "title": "Developers, Ready for a New SQL Server Version?", "url": "https://michaeljswart.com/2014/11/devs_ready_for_a_new_version/", "published_at": "2014-11-20T19:04:55+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841e96ee3a4", "title": "Watch Out for Misleading Behaviour From SQL Server", "url": "https://michaeljswart.com/2014/10/watch-out-for-misleading-behaviour-from-sql-server/", "published_at": "2014-10-03T13:36:06+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ea6d7fc5", "title": "SQL Server Ignores Trailing Spaces In Identifiers", "url": "https://michaeljswart.com/2014/09/sql-server-ignores-trailing-spaces-in-identifiers/", "published_at": "2014-09-18T14:27:17+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841eb60b1c0", "title": "Take Care When Scripting Batches", "url": "https://michaeljswart.com/2014/09/take-care-when-scripting-batches/", "published_at": "2014-09-09T17:22:02+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ec343dce", "title": "Trivia about Trivial Plans", "url": "https://michaeljswart.com/2014/06/trivia-about-trivial-plans/", "published_at": "2014-06-27T16:43:44+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ece969c1", "title": "Looking Back at 100 Illustrations", "url": "https://michaeljswart.com/2014/06/looking-back-at-100-illustrations/", "published_at": "2014-06-25T17:05:40+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ed9592e8", "title": "Enabling the New Cardinality Estimator in SQL Server 2014", "url": "https://michaeljswart.com/2014/05/enabling_the_new_ce/", "published_at": "2014-05-22T12:33:55+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ee915b3b", "title": "I’m Going To Help You Become A Better Writer", "url": "https://michaeljswart.com/2014/05/im-going-to-help-you-become-a-better-writer/", "published_at": "2014-05-08T15:06:11+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ef2d80d5", "title": "Removing Comments from SQL", "url": "https://michaeljswart.com/2014/04/removing-comments-from-sql/", "published_at": "2014-04-23T14:20:24+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841ef3aa5f5", "title": "Implementing the Recycle Bin Pattern In SQL", "url": "https://michaeljswart.com/2014/04/implementing-the-recycle-bin-pattern-in-sql/", "published_at": "2014-04-11T12:00:26+00:00" }, { "id": "01a0bbd2-2e38-7111-ae8d-8841efd7c7cd", "title": "A Primer on Locks, Blocks and Deadlocks", "url": "https://michaeljswart.com/2014/03/a-primer-on-locks-blocks-and-deadlocks/", "published_at": "2014-03-18T12:50:03+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e04d7771", "title": "T-SQL Tuesday #52 Round-Up: Argue Against a Popular Opinion", "url": "https://michaeljswart.com/2014/03/tsql2sday_52_roundup/", "published_at": "2014-03-16T17:52:33+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e1217b9f", "title": "I Don’t Mind SELECT * Sometimes", "url": "https://michaeljswart.com/2014/03/dont_mind_select_star/", "published_at": "2014-03-11T03:50:48+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e198830d", "title": "T-SQL Tuesday #052: Argue Against A Popular Opinion", "url": "https://michaeljswart.com/2014/03/argue_against_a_popular_opinion/", "published_at": "2014-03-04T03:07:46+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e27b95cb", "title": "Troubleshooting Concurrency – A Demo", "url": "https://michaeljswart.com/2014/02/troubleshooting-concurrency-a-demo/", "published_at": "2014-02-13T15:00:09+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e281f4f6", "title": "Building Concurrency Tests", "url": "https://michaeljswart.com/2014/01/building-concurrency-tests/", "published_at": "2014-01-30T14:11:13+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e36af5cd", "title": "Generating Concurrent Activity", "url": "https://michaeljswart.com/2014/01/generating-concurrent-activity/", "published_at": "2014-01-23T15:21:05+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e405fcfa", "title": "SQL Simplicity Methods", "url": "https://michaeljswart.com/2014/01/sql-simplicity-methods/", "published_at": "2014-01-06T14:00:30+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e4a669a6", "title": "“Make Sure That You Really Love Doing It”", "url": "https://michaeljswart.com/2013/12/just-one-piece-of-advice-for-aspiring-dbas/", "published_at": "2013-12-10T10:00:59+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e5859f68", "title": "Overly Complex Views, Procedures And Functions", "url": "https://michaeljswart.com/2013/12/overly-complex/", "published_at": "2013-12-04T21:03:38+00:00" }, { "id": "01a0bbd6-12e8-70df-84f9-baa5e5ad4090", "title": "Hashing for Indexes", "url": "https://michaeljswart.com/2013/11/hashing-for-indexes/", "published_at": "2013-11-22T05:07:42+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c71312666c4", "title": "“You’ve got access, but I’m not sure why”", "url": "https://michaeljswart.com/2013/10/youve-got-access-but-im-not-sure-why/", "published_at": "2013-10-30T13:00:03+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c7131614865", "title": "My Queries For Top 20 Resource Hogs", "url": "https://michaeljswart.com/2013/09/my-queries-for-top-20-resource-hogs/", "published_at": "2013-09-19T16:00:14+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c71320c427e", "title": "Without ORDER BY, You Can’t Depend On the Order of Results", "url": "https://michaeljswart.com/2013/09/without-order-by-you-cant-depend-on-the-order-of-results/", "published_at": "2013-09-13T14:25:45+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c7132e60fdf", "title": "Three More Tricky Tempdb Lessons", "url": "https://michaeljswart.com/2013/09/three-more-tricky-tempdb-lessons/", "published_at": "2013-09-11T16:00:13+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c7133d2ea26", "title": "A Tuning Technique For Parallel Queries", "url": "https://michaeljswart.com/2013/08/a-tuning-technique-for-parallel-queries/", "published_at": "2013-08-15T16:00:04+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c71349c6e12", "title": "Lessons From Sherlock Holmes", "url": "https://michaeljswart.com/2013/07/lessons-from-sherlock-holmes/", "published_at": "2013-07-30T03:41:47+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c7134e17487", "title": "It Took Me Ages To Figure This One Out: A Puzzle", "url": "https://michaeljswart.com/2013/07/it-took-me-ages-to-figure-this-one-out-a-puzzle/", "published_at": "2013-07-03T16:00:41+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c713537f03f", "title": "Swart’s Ten Percent Rule", "url": "https://michaeljswart.com/2013/05/swarts-ten-percent-rule/", "published_at": "2013-05-28T16:00:34+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c7135fee5e8", "title": "Myself in 2004", "url": "https://michaeljswart.com/2013/05/myself-in-2004/", "published_at": "2013-05-14T15:53:50+00:00" }, { "id": "01a0bbd9-b7d9-7304-b1fc-8c71369ba49c", "title": "The Sch-M lock is Evil", "url": "https://michaeljswart.com/2013/04/the-sch-m-lock-is-evil/", "published_at": "2013-04-17T16:00:35+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c68d86d15c", "title": "T-SQL Tuesday #41 – Presenting and loving it?", "url": "https://michaeljswart.com/2013/04/t-sql-tuesday-41-presenting-and-loving-it/", "published_at": "2013-04-09T00:00:51+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c68dab15a8", "title": "Splitting Time Between Hobbies", "url": "https://michaeljswart.com/2013/04/splitting-time-between-hobbies/", "published_at": "2013-04-03T16:00:33+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c68def1bf4", "title": "Altering Text Columns: Only a Metadata Change?", "url": "https://michaeljswart.com/2013/04/altering-text-columns-only-a-metadata-change/", "published_at": "2013-04-03T12:00:50+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c68eabb968", "title": "Checking Out Amazon Redshift", "url": "https://michaeljswart.com/2013/03/checking-out-amazon-redshift/", "published_at": "2013-03-19T19:00:12+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c68f967e1e", "title": "Follow up on Ad Hoc TVP contention", "url": "https://michaeljswart.com/2013/02/follow-up-on-ad-hoc-tvp-contention/", "published_at": "2013-02-28T17:00:19+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c690508ab8", "title": "Some Failed Blog Topics", "url": "https://michaeljswart.com/2013/02/some-failed-blog-topics/", "published_at": "2013-02-08T22:08:42+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c690df1d3f", "title": "PAGELATCH_EX Contention on 2:1:103", "url": "https://michaeljswart.com/2013/01/pagelatch-contention-on-21103/", "published_at": "2013-01-22T17:00:36+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c691114708", "title": "Joins are Commutative and SQL Server Knows it", "url": "https://michaeljswart.com/2013/01/joins-are-commutative-and-sql-server-knows-it/", "published_at": "2013-01-11T14:00:22+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c691dc20f7", "title": "A Grade School Data Project", "url": "https://michaeljswart.com/2012/12/a-grade-school-data-project/", "published_at": "2012-12-18T17:00:33+00:00" }, { "id": "01a0bbdd-5f3d-7392-a1b8-c4c691eed890", "title": "Well That Wasn’t Obvious", "url": "https://michaeljswart.com/2012/12/well-that-wasnt-obvious/", "published_at": "2012-12-05T17:00:01+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badba9413f8", "title": "Creativity, Birthdays and Were Snarf", "url": "https://michaeljswart.com/2012/11/creativity-birthdays-and-were-snarf/", "published_at": "2012-11-22T17:00:09+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbb08f87f", "title": "Triggers On Views? What For?", "url": "https://michaeljswart.com/2012/10/triggers-on-views-what-for/", "published_at": "2012-10-31T16:00:00+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbbd3ae11", "title": "You Can “Do Science” Anywhere", "url": "https://michaeljswart.com/2012/10/you-can-do-science-anywhere/", "published_at": "2012-10-11T16:00:03+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbc824b8b", "title": "My Short Struggle With SQL Agent", "url": "https://michaeljswart.com/2012/09/my-short-struggle-with-sql-agent/", "published_at": "2012-09-27T16:00:43+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbd3879eb", "title": "A Quick SQL Challenge", "url": "https://michaeljswart.com/2012/09/a-quick-sql-challenge/", "published_at": "2012-09-27T01:21:21+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbd8cfdc1", "title": "Some Announcements", "url": "https://michaeljswart.com/2012/09/some-announcements/", "published_at": "2012-09-21T14:36:02+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbe331b1e", "title": "When I Use Nested Joins", "url": "https://michaeljswart.com/2012/09/when-i-use-nested-joins/", "published_at": "2012-09-12T16:00:32+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbe6f1f2b", "title": "Sharpshooting Query Plans From The Cache", "url": "https://michaeljswart.com/2012/08/sharpshooting-query-plans-from-the-cache/", "published_at": "2012-08-28T16:00:07+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbee857ea", "title": "Be Careful with the Merge Statement", "url": "https://michaeljswart.com/2012/08/be-careful-with-the-merge-statement/", "published_at": "2012-08-17T12:38:28+00:00" }, { "id": "01a0bbe0-cc0f-7394-94b1-4badbef04439", "title": "Avoiding Problems", "url": "https://michaeljswart.com/2012/08/avoiding-problems/", "published_at": "2012-08-10T12:00:36+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5e95a086f", "title": "Data Modelling: Composite Relationships", "url": "https://michaeljswart.com/2012/07/part-of/", "published_at": "2012-07-26T16:00:22+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ea0ca3ed", "title": "T-SQL Tuesday #32 – A Day in the Life", "url": "https://michaeljswart.com/2012/07/t-sql-tuesday-32-a-day-in-the-life/", "published_at": "2012-07-17T12:00:23+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5eaf1528a", "title": "Developing on the Right Side of the Brain", "url": "https://michaeljswart.com/2012/07/developing-on-the-right-side-of-the-brain/", "published_at": "2012-07-12T16:00:39+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ebbb4a08", "title": "Go Democracy!", "url": "https://michaeljswart.com/2012/07/go-democracy/", "published_at": "2012-07-04T17:54:22+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ec3f99b1", "title": "Visualizing Transaction Isolations For SQL Server", "url": "https://michaeljswart.com/2012/06/visualizing-transaction-isolations-for-sql-server/", "published_at": "2012-06-13T16:00:03+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ec45a4a4", "title": "I’m Sharing My Story at SQL Brit’s Site", "url": "https://michaeljswart.com/2012/06/im-sharing-my-story-at-sql-brits-site/", "published_at": "2012-06-13T12:44:55+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ecfccaf9", "title": "MERGE Statement Generator", "url": "https://michaeljswart.com/2012/05/t-sql-merge-statement-syntax-generator/", "published_at": "2012-05-30T16:00:45+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ed285809", "title": "The View of Foreign Keys That I Wanted", "url": "https://michaeljswart.com/2012/05/the-view-of-foreign-keys-that-i-wanted/", "published_at": "2012-05-24T00:47:47+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5ee079bb9", "title": "Modifying Tables Online – Part 5: Just One More Thing", "url": "https://michaeljswart.com/2012/04/modifying-tables-online-part-5-just-one-more-thing/", "published_at": "2012-04-27T14:50:29+00:00" }, { "id": "01a0bbe4-071b-7087-9a8e-13d5eecb531d", "title": "Modifying Tables Online – Part 4: Testing", "url": "https://michaeljswart.com/2012/04/modifying-tables-online-part-4-testing/", "published_at": "2012-04-26T16:00:25+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f05ac9a6d", "title": "Modifying Tables Online – Part 3: Example With Error Handling", "url": "https://michaeljswart.com/2012/04/modifying-tables-online-part-3-example-with-error-handling/", "published_at": "2012-04-20T17:56:56+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f06a26bdd", "title": "Modifying Tables Online – Part 2: Implementation Example", "url": "https://michaeljswart.com/2012/04/modifying-tables-online-part-2-implementation-example/", "published_at": "2012-04-17T16:00:31+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f06c98cf4", "title": "Modifying Tables Online – Part 1: Migration Strategy", "url": "https://michaeljswart.com/2012/04/modifying-tables-online-part-1-migration-strategy/", "published_at": "2012-04-16T16:00:08+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f06dbc7bd", "title": "Portrait Contest (results)", "url": "https://michaeljswart.com/2012/04/portrait-contest-results/", "published_at": "2012-04-11T03:08:58+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f073011f4", "title": "Sending Query Results to Others", "url": "https://michaeljswart.com/2012/03/sending-query-results-to-others/", "published_at": "2012-03-28T16:00:17+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f0732784e", "title": "I’ll Draw Your Portrait", "url": "https://michaeljswart.com/2012/03/ill-draw-your-portrait/", "published_at": "2012-03-19T22:19:52+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f07817d16", "title": "SQL Server 2012 Launches Today", "url": "https://michaeljswart.com/2012/03/sql-server-2012-launches-today/", "published_at": "2012-03-07T06:08:08+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f07cd3f40", "title": "I Was Kidding Myself", "url": "https://michaeljswart.com/2012/02/i-was-kidding-myself/", "published_at": "2012-02-27T23:34:36+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f083e283a", "title": "Careful Hashing", "url": "https://michaeljswart.com/2012/02/careful-hashing/", "published_at": "2012-02-15T17:00:28+00:00" }, { "id": "01a0bbe7-424f-716a-bc24-841f0921fc76", "title": "Microsoft Model Databases: Some Unconventional Alternatives?", "url": "https://michaeljswart.com/2012/02/microsoft-model-databases-some-unconventional-alternatives/", "published_at": "2012-02-10T01:53:12+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443b476877", "title": "Removing Duplicate Dimension Rows in SSIS", "url": "https://michaeljswart.com/2012/02/removing-duplicate-dimension-rows-in-ssis/", "published_at": "2012-02-02T09:00:39+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443c33d46c", "title": "Rebuild Your Indexes Online (When You Can)", "url": "https://michaeljswart.com/2012/01/rebuild-your-indexes-online-when-you-can/", "published_at": "2012-01-25T17:00:41+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443ccd9761", "title": "My favourite search terms", "url": "https://michaeljswart.com/2012/01/my-favourite-search-terms/", "published_at": "2012-01-18T17:00:06+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443cd3eb1c", "title": "Clearing out the closet…", "url": "https://michaeljswart.com/2012/01/clearing-out-the-closet/", "published_at": "2012-01-17T19:31:15+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443d6f3c1b", "title": "Thank you notes…", "url": "https://michaeljswart.com/2012/01/thank-you-notes/", "published_at": "2012-01-13T17:00:56+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443e0934cb", "title": "Then, Now and Later", "url": "https://michaeljswart.com/2012/01/then-now-and-later/", "published_at": "2012-01-04T17:00:37+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443e5719db", "title": "A simple message: Merry Christmas", "url": "https://michaeljswart.com/2011/12/a-simple-message-merry-christmas/", "published_at": "2011-12-22T15:00:49+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443f496dd9", "title": "Write Better", "url": "https://michaeljswart.com/2011/12/write-better/", "published_at": "2011-12-21T04:20:14+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94443f6b2bfc", "title": "CXPACKET? What’s That? And What’s Next?", "url": "https://michaeljswart.com/2011/12/cxpacket-whats-that-and-whats-next/", "published_at": "2011-12-09T01:54:32+00:00" }, { "id": "01a0bbeb-81d1-731d-b968-94444059ceae", "title": "SQL Fingertips", "url": "https://michaeljswart.com/2011/11/sql-fingertips/", "published_at": "2011-11-29T04:36:53+00:00" } ] posts Claim your blog

Back to michaeljswart.com

Blog · corpus.blog/blogs/michaeljswart.com/posts

michaeljswart.com

michaeljswart.com

2016

My Work Autobiography original ↗

13 Jan 2016

Some Changes for 2016 original ↗

6 Jan 2016

2015

Don’t Abandon Your Transactions original ↗

6 Oct 2015

Code Review This Procedure original ↗

1 Oct 2015

Troubleshooting Tempdb, a Case Study original ↗

15 Sept 2015

Avoid Frequent use of TVPs With Wide Rows original ↗

31 Aug 2015

What’s Going On Inside Tempdb?original ↗

12 Aug 2015

Types of Performance Metrics original ↗

5 Aug 2015

How to Create Indexed Views Online original ↗

24 Jun 2015

It’s Hard To Destroy Data original ↗

20 May 2015

The Appeal Of Lightning Talks original ↗

27 Apr 2015

Finding Scalar Aggregate Indexed Views in Your Database original ↗

6 Apr 2015

Look at Blocking By Index original ↗

2 Apr 2015

Some Tweets I Drew original ↗

1 Apr 2015

Swart Draws Your Tweets original ↗

18 Mar 2015

When Parameter Sniffing Caused Deadlocks original ↗

26 Feb 2015

Designing Indexed Views for OLTP Workloads original ↗

23 Jan 2015

2014

Obvious and Not-So-Obvious Writing Tips original ↗

12 Dec 2014

Materialized Views in SQL Server original ↗

3 Dec 2014

Developers, Ready for a New SQL Server Version?original ↗

20 Nov 2014

Watch Out for Misleading Behaviour From SQL Server original ↗

3 Oct 2014

SQL Server Ignores Trailing Spaces In Identifiers original ↗

18 Sept 2014

Take Care When Scripting Batches original ↗

9 Sept 2014

Trivia about Trivial Plans original ↗

27 Jun 2014

Looking Back at 100 Illustrations original ↗

25 Jun 2014

Enabling the New Cardinality Estimator in SQL Server 2014 original ↗

22 May 2014

I’m Going To Help You Become A Better Writer original ↗

8 May 2014

Removing Comments from SQL original ↗

23 Apr 2014

Implementing the Recycle Bin Pattern In SQL original ↗

11 Apr 2014

A Primer on Locks, Blocks and Deadlocks original ↗

18 Mar 2014

T-SQL Tuesday #52 Round-Up: Argue Against a Popular Opinion original ↗

16 Mar 2014

I Don’t Mind SELECT * Sometimes original ↗

11 Mar 2014

T-SQL Tuesday #052: Argue Against A Popular Opinion original ↗

4 Mar 2014

Troubleshooting Concurrency – A Demo original ↗

13 Feb 2014

Building Concurrency Tests original ↗

30 Jan 2014

Generating Concurrent Activity original ↗

23 Jan 2014

SQL Simplicity Methods original ↗

6 Jan 2014

2013

“Make Sure That You Really Love Doing It”original ↗

10 Dec 2013

Overly Complex Views, Procedures And Functions original ↗

4 Dec 2013

Hashing for Indexes original ↗

22 Nov 2013

“You’ve got access, but I’m not sure why”original ↗

30 Oct 2013

My Queries For Top 20 Resource Hogs original ↗

19 Sept 2013

Without ORDER BY, You Can’t Depend On the Order of Results original ↗

13 Sept 2013

Three More Tricky Tempdb Lessons original ↗

11 Sept 2013

A Tuning Technique For Parallel Queries original ↗

15 Aug 2013

Lessons From Sherlock Holmes original ↗

30 Jul 2013

It Took Me Ages To Figure This One Out: A Puzzle original ↗

3 Jul 2013

Swart’s Ten Percent Rule original ↗

28 May 2013

Myself in 2004 original ↗

14 May 2013

The Sch-M lock is Evil original ↗

17 Apr 2013

T-SQL Tuesday #41 – Presenting and loving it?original ↗

9 Apr 2013

Splitting Time Between Hobbies original ↗

3 Apr 2013

Altering Text Columns: Only a Metadata Change?original ↗

3 Apr 2013

Checking Out Amazon Redshift original ↗

19 Mar 2013

Follow up on Ad Hoc TVP contention original ↗

28 Feb 2013

Some Failed Blog Topics original ↗

8 Feb 2013

PAGELATCH_EX Contention on 2:1:103 original ↗

22 Jan 2013

Joins are Commutative and SQL Server Knows it original ↗

11 Jan 2013

2012

A Grade School Data Project original ↗

18 Dec 2012

Well That Wasn’t Obvious original ↗

5 Dec 2012

Creativity, Birthdays and Were Snarf original ↗

22 Nov 2012

Triggers On Views? What For?original ↗

31 Oct 2012

You Can “Do Science” Anywhere original ↗

11 Oct 2012

My Short Struggle With SQL Agent original ↗

27 Sept 2012

A Quick SQL Challenge original ↗

27 Sept 2012

Some Announcements original ↗

21 Sept 2012

When I Use Nested Joins original ↗

12 Sept 2012

Sharpshooting Query Plans From The Cache original ↗

28 Aug 2012

Be Careful with the Merge Statement original ↗

17 Aug 2012

Avoiding Problems original ↗

10 Aug 2012

Data Modelling: Composite Relationships original ↗

26 Jul 2012

T-SQL Tuesday #32 – A Day in the Life original ↗

17 Jul 2012

Developing on the Right Side of the Brain original ↗

12 Jul 2012

Go Democracy!original ↗

4 Jul 2012

Visualizing Transaction Isolations For SQL Server original ↗

13 Jun 2012

I’m Sharing My Story at SQL Brit’s Site original ↗

13 Jun 2012

MERGE Statement Generator original ↗

30 May 2012

The View of Foreign Keys That I Wanted original ↗

24 May 2012

Modifying Tables Online – Part 5: Just One More Thing original ↗

27 Apr 2012

Modifying Tables Online – Part 4: Testing original ↗

26 Apr 2012

Modifying Tables Online – Part 3: Example With Error Handling original ↗

20 Apr 2012

Modifying Tables Online – Part 2: Implementation Example original ↗

17 Apr 2012

Modifying Tables Online – Part 1: Migration Strategy original ↗

16 Apr 2012

Portrait Contest (results)original ↗

11 Apr 2012

Sending Query Results to Others original ↗

28 Mar 2012

I’ll Draw Your Portrait original ↗

19 Mar 2012

SQL Server 2012 Launches Today original ↗

7 Mar 2012

I Was Kidding Myself original ↗

27 Feb 2012

Careful Hashing original ↗

15 Feb 2012

Microsoft Model Databases: Some Unconventional Alternatives?original ↗

10 Feb 2012

Removing Duplicate Dimension Rows in SSIS original ↗

2 Feb 2012

Rebuild Your Indexes Online (When You Can)original ↗

25 Jan 2012

My favourite search terms original ↗

18 Jan 2012

Clearing out the closet…original ↗

17 Jan 2012

Thank you notes…original ↗

13 Jan 2012

Then, Now and Later original ↗

4 Jan 2012

2011

A simple message: Merry Christmas original ↗

22 Dec 2011

Write Better original ↗

21 Dec 2011

CXPACKET? What’s That? And What’s Next?original ↗

9 Dec 2011

SQL Fingertips original ↗

29 Nov 2011