Blog - Page 16 of 25 - SQLServerFast

T-SQL Tuesday #104: Make Ola backup BizTalk

July 10, 2018

In 2009, Adam Machanic (b|t) started the monthly blog event known as T-SQL Tuesday. One person picks a topic, and everyone is invited to blog about it on the second Tuesday of the month. The July 2018 host is Bert Wagner (b|t), and his chosen topic is: Code You Would Hate To Live Without. Talk about a broad topic! I could fill a book on that topic, and the same probably goes for many others. But since my time is limited, I have decided to cherry-pick just two of my favorite scripts. This post is about the second: a small…

T-SQL Tuesday #104 (part 1): sp_metasearch

July 10, 2018

Hugo Kornelis

2

In 2009, Adam Machanic (b|t) started the monthly blog event known as T-SQL Tuesday. One person picks a topic, and everyone is invited to blog about it on the second Tuesday of the month. The July 2018 host is Bert Wagner (b|t), and his chosen topic is: Code You Would Hate To Live Without. Talk about a broad topic! I could fill a book on that topic, and the same probably goes for many others. But since my time is limited, I have decided to cherry-pick just two of my favorite scripts. This post is about the first: sp_metasearch. Impact…

Plansplaining, part 7. The Constant Scan that returns no data

July 2, 2018

Hugo Kornelis

No Comments

This is part seven of the plansplaining series. Each of these posts takes an execution plan with an interesting pattern, and details exactly how that plan works. In this post we look at a deceptively simple query: a simple SELECT with an ISNULL to show either a row returned or a placeholder value. And yet there is more going on under the covers than one might expect. Sample query The query below can be executed in any version of the AdventureWorks sample database. It returns a code string representing the version number on the 2016 and 2017 versions; on older…

Plansplaining, part 6. Aggregates with OVER.

June 4, 2018

Hugo Kornelis

2

This is the sixth post in the plansplaining series. Each of these blog posts focuses on a sample execution plan that exposes an uncommon and interesting pattern, and details exactly how that plan works. In the first post, I covered each individual step of each operator in great detail, to make sure that everyone understands exactly how operators work in the pull-based execution plans. In this post (and all future installments), I will leave out the details that I now assume to be known to my readers. If you did not read part 1 already, I suggest you start there.…

Announcing: The SQL Server Execution Plan Reference

May 31, 2018

Hugo Kornelis

1

As some of you might already know, Grant Fritchey is working hard on updating his book on execution plans. The refreshed and much-improved third edition should release “real soon now”. And I happen to be involved in this project, as technical editor. While working on that book, I often ran into interesting and intriguing details in the execution plans. Details that, more often than not, are well beyond the scope of the book. So they will not be included, and rightly so. But it felt like a shame to have that information not available anywhere. Or scattered across the internet…

T-SQL Tuesday #102: Announcing a new site

May 8, 2018

Hugo Kornelis

2

Back in 2009, Adam Machanic (b|t) started an initiative that is still going strong: T-SQL Tuesday. This is a monthly blog party. Every second Tuesday of each month, lots of people blog about the same topic, selected by the host for that month. The May 2018 edition, better known as #102, is hosted by Riley Major (b|t). His challenge for this month: give back to the community. Pick an activity to help the community, explain your choice, and then commit to it. And include an ETA. If ever I saw a scary T-SQL Tuesday challenge, this has to be it.…

Plansplaining, part 5. Bitmaps

May 7, 2018

Hugo Kornelis

9

This is the fifth post in the plansplaining series. Each of these blog posts focuses on a sample execution plan that exposes an uncommon and interesting pattern, and details exactly how that plan works. In the first post, I covered each individual step of each operator in great detail, to make sure that everyone understands exactly how operators work in the pull-based execution plans. In this post (and all future installments), I will leave out the details that I now assume to be known to my readers. If you did not read part 1 already, I suggest you start there.…

The Segment operator, an error in Books Online

April 22, 2018

Hugo Kornelis

2

If you are as obsessed with execution plans as I am, you must be familiar with this page in Books Online: Showplan Logical and Physical Operators Reference. I must admit that I have mixed feelings about it. My problem with this page is the confusing way in which it mixes physical operators, logical operations (called logical operators on that page to add to the confusion), and operators that only exist in intermediate phases of query optimization and that we will never see in actual execution plans. But I do like it for presenting all operators that exist, with a short…

T-SQL Tuesday #101: A few of my favorite tools

April 11, 2018

Hugo Kornelis

1

Back in 2009, Adam Machanic (b|t) started an initiative that is still going strong: T-SQL Tuesday. This is a monthly blog party. Every second Tuesday of each month, lots of people blog about the same topic, selected by the host for that month. And now, in the 99th installment, I decided to finally join in! The April 2018 edition is hosted by Jens Vestergaard (b|t). His challenge for this month: write about the tools, other than SSMS and VSDT, that we use for our work. Essential tools The full invitation even includes words such as “essential” tools, and “depend on…

Plansplaining, part 4. Let’s repartition the streams.

April 2, 2018

Hugo Kornelis

3

This is the fourth post in the plansplaining series. Each of these blog posts focuses on a sample execution plan that exposes an uncommon and interesting pattern, and details exactly how that plan works. In the first post, I covered each individual step of each operator in great detail, to make sure that everyone understands exactly how operators work in the pull-based execution plans. In this post (and all future installments), I will leave out the details that I now assume to be known to my readers. If you did not read part 1 already, I suggest you start there.…

T-SQL Tuesday #104: Make Ola backup BizTalk

T-SQL Tuesday #104 (part 1): sp_metasearch

Plansplaining, part 7. The Constant Scan that returns no data

Plansplaining, part 6. Aggregates with OVER.

Announcing: The SQL Server Execution Plan Reference

T-SQL Tuesday #102: Announcing a new site

Plansplaining, part 5. Bitmaps

The Segment operator, an error in Books Online

T-SQL Tuesday #101: A few of my favorite tools

Plansplaining, part 4. Let’s repartition the streams.

Plansplaining, part 18. Temporal tables (part 3)

Free video on percentages in execution plans

T-SQL Tuesday #139 – Execution plans in a hybrid world

Plansplaining, part 19. Temporal tables (part 4)

Recorded conference sessions

Black Friday sale

Here’s the execution plan … now what?

Breaking the silence

Execution Plans in Azure Data Studio

T-SQL Tuesday #150 – My first technical job

Hugo Kornelis

Meta

Archives