corpus.blog
41554 blogs · [ { "id": "01a0d1d6-560a-7118-9d38-5a2a8ada54d7", "title": "Fake statistics, and how to get rid of them", "url": "https://sqlserverfast.com/blog/hugo/2014/03/fake-statistics-and-how-to-get-rid-of-them/", "published_at": "2014-03-02T12:35:08+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8b9510d4", "title": "Database Design training – for free?", "url": "https://sqlserverfast.com/blog/hugo/2014/01/database-design-training-for-free/", "published_at": "2014-01-30T00:58:25+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8c7eb966", "title": "Parameterization and filtered indexes (part 2)", "url": "https://sqlserverfast.com/blog/hugo/2014/01/parameterization-and-filtered-indexes-part-2/", "published_at": "2014-01-24T03:43:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8ce46fce", "title": "Parameterization and filtered indexes (part 1)", "url": "https://sqlserverfast.com/blog/hugo/2014/01/parameterization-and-filtered-indexes-part-1/", "published_at": "2014-01-19T23:29:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8d25afaf", "title": "Understanding Execution Plans", "url": "https://sqlserverfast.com/blog/hugo/2013/12/understanding-execution-plans/", "published_at": "2013-12-12T23:19:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8ddf6acb", "title": "SQLRally and SQLRally – Session material", "url": "https://sqlserverfast.com/blog/hugo/2013/11/sqlrally-and-sqlrally-session-material/", "published_at": "2013-11-09T14:41:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8deb3879", "title": "Decks and demos – Session material for Silicon Valley Code Camp", "url": "https://sqlserverfast.com/blog/hugo/2013/10/decks-and-demos-session-material-for-silicon-valley-code-camp/", "published_at": "2013-10-05T07:38:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8e6e9094", "title": "Book review: SQL Server Transaction Log Management", "url": "https://sqlserverfast.com/blog/hugo/2013/06/book-review-sql-server-transaction-log-management/", "published_at": "2013-06-15T15:20:00+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8e8e9381", "title": "Jetzt geht’s los – speaking in Germany!", "url": "https://sqlserverfast.com/blog/hugo/2013/06/jetzt-gehts-los-speaking-in-germany/", "published_at": "2013-06-10T00:37:28+00:00" }, { "id": "01a0d1d6-560a-7118-9d38-5a2a8f7905ea", "title": "Why does SQL Server not compress data on LOB pages?", "url": "https://sqlserverfast.com/blog/hugo/2013/01/why-does-sql-server-not-compress-data-on-lob-pages/", "published_at": "2013-01-31T11:08:03+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306add7d86a", "title": "Bleeding Edge 2012 – session material", "url": "https://sqlserverfast.com/blog/hugo/2012/10/bleeding-edge-2012-session-material/", "published_at": "2012-10-27T13:46:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306ae53381a", "title": "SQLRally Nordic 2012 – session material", "url": "https://sqlserverfast.com/blog/hugo/2012/10/sqlrally-nordic-2012-session-material/", "published_at": "2012-10-05T19:49:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306aee8b9a0", "title": "T-SQL User-Defined Functions: the good, the bad, and the ugly (part 4)", "url": "https://sqlserverfast.com/blog/hugo/2012/08/t-sql-user-defined-functions-the-good-the-bad-and-the-ugly-part-4/", "published_at": "2012-08-25T00:07:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306af9fca0d", "title": "Upcoming speaking engagements – want to meet me?", "url": "https://sqlserverfast.com/blog/hugo/2012/08/upcoming-speaking-engagements-want-to-meet-me/", "published_at": "2012-08-24T00:28:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b097ae23", "title": "T-SQL User-Defined Functions: the good, the bad, and the ugly (part 3)", "url": "https://sqlserverfast.com/blog/hugo/2012/06/t-sql-user-defined-functions-the-good-the-bad-and-the-ugly-part-3/", "published_at": "2012-06-29T21:44:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b09b4195", "title": "T-SQL User-Defined Functions: the good, the bad, and the ugly (part 2)", "url": "https://sqlserverfast.com/blog/hugo/2012/05/t-sql-user-defined-functions-the-good-the-bad-and-the-ugly-part-2/", "published_at": "2012-05-26T17:56:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b184d026", "title": "T-SQL User-Defined Functions: the good, the bad, and the ugly (part 1)", "url": "https://sqlserverfast.com/blog/hugo/2012/05/t-sql-user-defined-functions-the-good-the-bad-and-the-ugly-part-1/", "published_at": "2012-05-20T17:08:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b23812ac", "title": "Principles of Modeling: Avoid Redundancy", "url": "https://sqlserverfast.com/blog/hugo/2012/05/principles-of-modeling-avoid-redundancy/", "published_at": "2012-05-05T22:31:12+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b2e765b8", "title": "The Curious Case of the Optimizer that doesn’t", "url": "https://sqlserverfast.com/blog/hugo/2012/05/the-curious-case-of-the-optimizer-that-doesnt/", "published_at": "2012-05-04T01:13:00+00:00" }, { "id": "01a0d1d6-798e-71cb-a2be-6306b38a226d", "title": "Slides and demo code for Columnstore Index session", "url": "https://sqlserverfast.com/blog/hugo/2012/04/slides-and-demo-code-for-columnstore-index-session/", "published_at": "2012-04-04T23:58:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc49923e1e7a", "title": "80% off for SQL Azure!", "url": "https://sqlserverfast.com/blog/hugo/2012/04/80-off-for-sql-azure/", "published_at": "2012-04-01T17:50:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc4992e80e02", "title": "Busy months ahead", "url": "https://sqlserverfast.com/blog/hugo/2012/02/busy-months-ahead/", "published_at": "2012-02-16T21:48:01+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc49937fbcfa", "title": "Principles of Modeling: the Reproducibility Principle", "url": "https://sqlserverfast.com/blog/hugo/2011/12/principles-of-modeling-the-reproducibility-principle/", "published_at": "2011-12-22T22:48:07+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc499433655a", "title": "Bin packing part 6: Further improvements", "url": "https://sqlserverfast.com/blog/hugo/2011/11/bin-packing-part-6-further-improvements/", "published_at": "2011-11-01T21:43:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc499511d467", "title": "Principles of Modeling: the Concreteness Principle", "url": "https://sqlserverfast.com/blog/hugo/2011/10/principles-of-modeling-the-concreteness-principle/", "published_at": "2011-10-29T00:41:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc4995a102ba", "title": "Principles of Modeling: the Jargon Principle", "url": "https://sqlserverfast.com/blog/hugo/2011/10/principles-of-modeling-the-jargon-principle/", "published_at": "2011-10-20T12:39:09+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc49960d48c3", "title": "Bin packing part 5: Set-based iteration", "url": "https://sqlserverfast.com/blog/hugo/2011/10/bin-packing-part-5-set-based-iteration/", "published_at": "2011-10-18T01:11:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc499615fd1a", "title": "Bin packing part 4: The set-based disaster", "url": "https://sqlserverfast.com/blog/hugo/2008/10/bin-packing-part-4-the-set-based-disaster/", "published_at": "2008-10-27T02:28:00+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc4996288ca5", "title": "Speaking at PASS", "url": "https://sqlserverfast.com/blog/hugo/2008/10/speaking-at-pass/", "published_at": "2008-10-27T02:22:51+00:00" }, { "id": "01a0d1d6-97cf-70e0-a788-bc4997126c20", "title": "Data modeling: art or science?", "url": "https://sqlserverfast.com/blog/hugo/2008/08/data-modeling-art-or-science/", "published_at": "2008-08-03T01:04:44+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f1980031c0f", "title": "[OT] Alive and kicking", "url": "https://sqlserverfast.com/blog/hugo/2008/08/ot-alive-and-kicking/", "published_at": "2008-08-03T01:01:30+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f198007b62f", "title": "Let’s deprecate UPDATE FROM!", "url": "https://sqlserverfast.com/blog/hugo/2008/03/lets-deprecate-update-from/", "published_at": "2008-03-10T02:38:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f198061b1da", "title": "Want a Service Pack? Ask for it!", "url": "https://sqlserverfast.com/blog/hugo/2008/02/want-a-service-pack-ask-for-it/", "published_at": "2008-02-01T22:19:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f1980edb0f4", "title": "Bin packing part 3: Need for speed", "url": "https://sqlserverfast.com/blog/hugo/2008/01/bin-packing-part-3-need-for-speed/", "published_at": "2008-01-12T00:24:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f1981a82949", "title": "Bin packing part 2: Packing it tighter", "url": "https://sqlserverfast.com/blog/hugo/2007/12/bin-packing-part-2-packing-it-tighter/", "published_at": "2007-12-24T00:33:40+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f19827e13ba", "title": "Bin packing part 1: Setting a baseline", "url": "https://sqlserverfast.com/blog/hugo/2007/11/bin-packing-part-1-setting-a-baseline/", "published_at": "2007-11-30T23:58:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f198301867a", "title": "Poor men see sharp – more cursor optimization", "url": "https://sqlserverfast.com/blog/hugo/2007/11/poor-men-see-sharp-more-cursor-optimization/", "published_at": "2007-11-28T00:47:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f1983b63a7c", "title": "Curious cursor optimization options", "url": "https://sqlserverfast.com/blog/hugo/2007/11/curious-cursor-optimization-options/", "published_at": "2007-11-21T02:15:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f19848171fd", "title": "So-called “exact” numerics are not at all exact!", "url": "https://sqlserverfast.com/blog/hugo/2007/10/so-called-exact-numerics-are-not-at-all-exact/", "published_at": "2007-10-17T01:42:00+00:00" }, { "id": "01a0d1d6-bd65-7203-861b-5f1985227876", "title": "How NOT to pass a lot of parameters", "url": "https://sqlserverfast.com/blog/hugo/2007/10/how-not-to-pass-a-lot-of-parameters/", "published_at": "2007-10-04T10:07:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddf9437d6a", "title": "What if null if null is null null null is null?", "url": "https://sqlserverfast.com/blog/hugo/2007/09/what-if-null-if-null-is-null-null-null-is-null/", "published_at": "2007-09-30T23:19:30+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfa3c9129", "title": "Dr. Unknown, or how I learned to stop worrying and love the NULL", "url": "https://sqlserverfast.com/blog/hugo/2007/09/dr-unknown-or-how-i-learned-to-stop-worrying-and-love-the-null/", "published_at": "2007-09-22T23:35:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfa537344", "title": "Upcoming speaking events", "url": "https://sqlserverfast.com/blog/hugo/2007/09/upcoming-speaking-events/", "published_at": "2007-09-10T00:54:12+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfafab4c2", "title": "A Better Developer in 6 months? Deal!", "url": "https://sqlserverfast.com/blog/hugo/2007/07/a-better-developer-in-6-months-deal/", "published_at": "2007-07-18T01:08:32+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfb2edd1f", "title": "The logic of three-valued logic", "url": "https://sqlserverfast.com/blog/hugo/2007/07/the-logic-of-three-valued-logic/", "published_at": "2007-07-17T23:58:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfc0311a4", "title": "NULL – The database’s black hole", "url": "https://sqlserverfast.com/blog/hugo/2007/07/null-the-databases-black-hole/", "published_at": "2007-07-06T00:20:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfc985b6e", "title": "The Bounding Box, corrected version", "url": "https://sqlserverfast.com/blog/hugo/2007/06/the-bounding-box-corrected-version/", "published_at": "2007-06-27T23:24:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfcca7e65", "title": "Going to Dublin", "url": "https://sqlserverfast.com/blog/hugo/2007/06/going-to-dublin/", "published_at": "2007-06-05T00:38:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfd56f739", "title": "Correcting my mistake", "url": "https://sqlserverfast.com/blog/hugo/2007/05/correcting-my-mistake/", "published_at": "2007-05-18T23:26:00+00:00" }, { "id": "01a0d1d6-d6f4-727b-8fa2-d7ddfe3555b5", "title": "Can you trust your constraints?", "url": "https://sqlserverfast.com/blog/hugo/2007/03/can-you-trust-your-constraints/", "published_at": "2007-03-29T17:21:12+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59c2e2a66", "title": "Back with a vengeance!", "url": "https://sqlserverfast.com/blog/hugo/2007/03/back-with-a-vengeance/", "published_at": "2007-03-29T17:11:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59c81df78", "title": "The Beatles versus the Stones – the explanation", "url": "https://sqlserverfast.com/blog/hugo/2007/01/the-beatles-versus-the-stones-the-explanation/", "published_at": "2007-01-16T22:44:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59d339678", "title": "The Beatles versus the Stones", "url": "https://sqlserverfast.com/blog/hugo/2006/12/the-beatles-versus-the-stones/", "published_at": "2006-12-31T13:49:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59d9c2a2d", "title": "The table scan from hell", "url": "https://sqlserverfast.com/blog/hugo/2006/11/the-table-scan-from-hell/", "published_at": "2006-11-03T19:55:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59e48b5ee", "title": "Just stuff it!", "url": "https://sqlserverfast.com/blog/hugo/2006/10/just-stuff-it/", "published_at": "2006-10-12T20:50:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59f3386ac", "title": "The prime number challenge – great waste of time!", "url": "https://sqlserverfast.com/blog/hugo/2006/09/the-prime-number-challenge-great-waste-of-time/", "published_at": "2006-09-23T22:54:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59fa79a96", "title": "Snapshot isolation: A threat for integrity? (Part 4)", "url": "https://sqlserverfast.com/blog/hugo/2006/09/snapshot-isolation-a-threat-for-integrity-part-4/", "published_at": "2006-09-15T20:58:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e59fbf75af", "title": "Fun with ambiguous table names", "url": "https://sqlserverfast.com/blog/hugo/2006/09/fun-with-ambiguous-table-names/", "published_at": "2006-09-02T21:24:00+00:00" }, { "id": "01a0d1d6-fbc3-72c0-b93a-74e5a0955b75", "title": "Snapshot isolation: A threat for integrity? (Part 3)", "url": "https://sqlserverfast.com/blog/hugo/2006/08/snapshot-isolation-a-threat-for-integrity-part-3/", "published_at": "2006-08-25T18:17:00+00:00" }, { "id": "01a0d1d6-fbc4-70c1-af80-1592c09229c2", "title": "Snapshot isolation: A threat for integrity? (Part 2)", "url": "https://sqlserverfast.com/blog/hugo/2006/07/snapshot-isolation-a-threat-for-integrity-part-2/", "published_at": "2006-07-26T18:12:00+00:00" }, { "id": "01a0d1d7-131c-7278-bd82-acd163ffb3c3", "title": "Snapshot isolation: A threat for integrity? (Part 1)", "url": "https://sqlserverfast.com/blog/hugo/2006/07/snapshot-isolation-a-threat-for-integrity-part-1/", "published_at": "2006-07-21T20:40:00+00:00" }, { "id": "01a0d1d7-131c-7278-bd82-acd1647eb7f8", "title": "Relating unrelated rows", "url": "https://sqlserverfast.com/blog/hugo/2006/07/relating-unrelated-rows/", "published_at": "2006-07-14T22:23:00+00:00" } ] posts Claim your blog
Back to sqlserverfast.com
Blog · corpus.blog/blogs/sqlserverfast.com/posts

sqlserverfast.com

sqlserverfast.com

2014

Fake statistics, and how to get rid of themoriginal ↗
2 Mar 2014
Database Design training – for free?original ↗
30 Jan 2014
Parameterization and filtered indexes (part 2)original ↗
24 Jan 2014
Parameterization and filtered indexes (part 1)original ↗
19 Jan 2014

2013

Understanding Execution Plansoriginal ↗
12 Dec 2013
SQLRally and SQLRally – Session materialoriginal ↗
9 Nov 2013
Decks and demos – Session material for Silicon Valley Code Camporiginal ↗
5 Oct 2013
Book review: SQL Server Transaction Log Managementoriginal ↗
15 Jun 2013
Jetzt geht’s los – speaking in Germany!original ↗
10 Jun 2013
Why does SQL Server not compress data on LOB pages?original ↗
31 Jan 2013

2012

Bleeding Edge 2012 – session materialoriginal ↗
27 Oct 2012
SQLRally Nordic 2012 – session materialoriginal ↗
5 Oct 2012
T-SQL User-Defined Functions: the good, the bad, and the ugly (part 4)original ↗
25 Aug 2012
Upcoming speaking engagements – want to meet me?original ↗
24 Aug 2012
T-SQL User-Defined Functions: the good, the bad, and the ugly (part 3)original ↗
29 Jun 2012
T-SQL User-Defined Functions: the good, the bad, and the ugly (part 2)original ↗
26 May 2012
T-SQL User-Defined Functions: the good, the bad, and the ugly (part 1)original ↗
20 May 2012
Principles of Modeling: Avoid Redundancyoriginal ↗
5 May 2012
The Curious Case of the Optimizer that doesn’toriginal ↗
4 May 2012
Slides and demo code for Columnstore Index sessionoriginal ↗
4 Apr 2012
80% off for SQL Azure!original ↗
1 Apr 2012
Busy months aheadoriginal ↗
16 Feb 2012

2011

Principles of Modeling: the Reproducibility Principleoriginal ↗
22 Dec 2011
Bin packing part 6: Further improvementsoriginal ↗
1 Nov 2011
Principles of Modeling: the Concreteness Principleoriginal ↗
29 Oct 2011
Principles of Modeling: the Jargon Principleoriginal ↗
20 Oct 2011
Bin packing part 5: Set-based iterationoriginal ↗
18 Oct 2011

2008

Bin packing part 4: The set-based disasteroriginal ↗
27 Oct 2008
Speaking at PASSoriginal ↗
27 Oct 2008
Data modeling: art or science?original ↗
3 Aug 2008
[OT] Alive and kickingoriginal ↗
3 Aug 2008
Let’s deprecate UPDATE FROM!original ↗
10 Mar 2008
Want a Service Pack? Ask for it!original ↗
1 Feb 2008
Bin packing part 3: Need for speedoriginal ↗
12 Jan 2008

2007

Bin packing part 2: Packing it tighteroriginal ↗
24 Dec 2007
Bin packing part 1: Setting a baselineoriginal ↗
30 Nov 2007
Poor men see sharp – more cursor optimizationoriginal ↗
28 Nov 2007
Curious cursor optimization optionsoriginal ↗
21 Nov 2007
So-called “exact” numerics are not at all exact!original ↗
17 Oct 2007
How NOT to pass a lot of parametersoriginal ↗
4 Oct 2007
What if null if null is null null null is null?original ↗
30 Sept 2007
Dr. Unknown, or how I learned to stop worrying and love the NULLoriginal ↗
22 Sept 2007
Upcoming speaking eventsoriginal ↗
10 Sept 2007
A Better Developer in 6 months? Deal!original ↗
18 Jul 2007
The logic of three-valued logicoriginal ↗
17 Jul 2007
NULL – The database’s black holeoriginal ↗
6 Jul 2007
The Bounding Box, corrected versionoriginal ↗
27 Jun 2007
Going to Dublinoriginal ↗
5 Jun 2007
Correcting my mistakeoriginal ↗
18 May 2007
Can you trust your constraints?original ↗
29 Mar 2007
Back with a vengeance!original ↗
29 Mar 2007
The Beatles versus the Stones – the explanationoriginal ↗
16 Jan 2007

2006

The Beatles versus the Stonesoriginal ↗
31 Dec 2006
The table scan from helloriginal ↗
3 Nov 2006
Just stuff it!original ↗
12 Oct 2006
The prime number challenge – great waste of time!original ↗
23 Sept 2006
Snapshot isolation: A threat for integrity? (Part 4)original ↗
15 Sept 2006
Fun with ambiguous table namesoriginal ↗
2 Sept 2006
Snapshot isolation: A threat for integrity? (Part 3)original ↗
25 Aug 2006
Snapshot isolation: A threat for integrity? (Part 2)original ↗
26 Jul 2006
Snapshot isolation: A threat for integrity? (Part 1)original ↗
21 Jul 2006
Relating unrelated rowsoriginal ↗
14 Jul 2006
Previous