Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Matan Yungman

Matan Yungman is a Technical Evangelist and senior consultant at Madeira SQL Server Services. His job is to get the word out about SQL Server. He speaks, lectures, writes, teaches and consults about SQL Server, focusing mainly on performance tuning, database development, high availability and database design. He’s passionate about SQL Server, technology and the SQL Server community.

Rebuilding and Reorganizing Clustered Columnstore Indexes

Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations is different in the case of Columnstore.

Before we describe the differences, let’s remind ourselves how data manipulation works in Columnstore:

Inserts go into an object called Delta Store,… Read more

4 comments, 3,319 reads

Posted in Matan Yungman on 11 December 2014

Tracking Progress of SQL Server Index Builds and Rebuilds

Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when the table will stop being blocked and when their precious queries will run fast. What can you tell them?

SQL Server allows tracking the progress of index build and rebuilds.… Read more

6 comments, 6,213 reads

Posted in Matan Yungman on 6 November 2014

Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.

A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows on to the next iterator without having… Read more

2 comments, 347 reads

Posted in Matan Yungman on 30 October 2014

Track My Query Utility

Were you ever in a situation where you ran a query, it ran for a long time and you didn’t know what it was doing? Sure you were..

What if you had a visual indication of where things are stuck in your execution plan, while the query is running?

A… Read more

14 comments, 6,425 reads

Posted in Matan Yungman on 1 October 2014

How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster

When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you understand a few things in order for your applications to work properly after a failover. For the sake of our discussion, let’s assume we have a multi-subnet… Read more

2 comments, 137 reads

Posted in Matan Yungman on 29 September 2014

My SQLBits Session Recordings

Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.

A few days ago, all of the session recordings were uploaded to the SQLBits site.

In my first session, “Query Progress Tracking in SQL Server“, I talked about… Read more

0 comments, 182 reads

Posted in Matan Yungman on 28 August 2014

Announcing SQL Server Radio – English Edition!

About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast about SQL Server. He was pretty surprised, but we started working on it.

We’ve been doing it for about a year now over at SQLServerRadio.co.il, and we love it.… Read more

0 comments, 661 reads

Posted in Matan Yungman on 14 August 2014

The Real Reason You Should Be a Proactive DBA

If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great things about SQL Server is the fact that it’s super easy to start working with it: You download the installation (or connect to the Azure portal and get a VM),… Read more

0 comments, 502 reads

Posted in Matan Yungman on 11 August 2014

Things You Can Find in the Plan Cache at SQLBits

On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!

Thanks to everyone who attended my session.

The scripts and presentation can be downloaded here.

 

The post Things You Can Find in the Plan Cache at SQLBits appeared… Read more

0 comments, 68 reads

Posted in Matan Yungman on 19 July 2014

Goodbye Microsoft, Hello New Adventure

About two months ago, after two and a half years, I left Microsoft.

Microsoft is an amazing place to work for. It’s comfortable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined… Read more

2 comments, 63 reads

Posted in Matan Yungman on 17 July 2014

Goodbye Microsoft, Hello New Adventure

About two months ago, after 2.5 years, I left Microsoft.

Microsoft is an amazing place to work for. It’s conformable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined perfectly to make… Read more

0 comments, 211 reads

Posted in Matan Yungman on 17 July 2014

The 3 Factors That Will Get You a Job You’ll Love

It’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews.

Over the time as a SQL Server professional, I’ve come to an understanding about 3 important interview-related factors you’ll need in order to find a job you’ll love (Of… Read more

2 comments, 247 reads

Posted in Matan Yungman on 13 May 2014

Webcast – Small Changes Can Make a World of Difference

This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small Changes Can Make a World of Difference”, talking about a bunch of “small” features that were introduced in SQL Server 2012 and 2014,… Read more

0 comments, 180 reads

Posted in Matan Yungman on 18 March 2014

A Community Challenge

Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.

Among other techniques, I showed how you can use CXPacket waits and the new sys.dm_exec_query_profiles DMV to track the progress of your query while it’s running.

The issue is that using… Read more

8 comments, 198 reads

Posted in Matan Yungman on 5 March 2014

The Strange Story About the MERGE that Killed the Cluster

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day a developer wanted my help in troubleshooting a MERGE that caused an ACCESS VIOLATION error and a stack dump generation. That… Read more

10 comments, 3,631 reads

Posted in Matan Yungman on 20 February 2014

Know When it’s Good Enough

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even more, I love challenges. But sometimes taking a query from the “good enough zone” down to “super-performance zone” will take a lot… Read more

4 comments, 314 reads

Posted in Matan Yungman on 28 January 2014

Things I Learned in 2013

It’s 2014 now. I hope you had fun in new year’s eve. 

2013 was an amazing and intense year. To recap it, I thought about sharing some of the things I learned:

SQL Server

  • I love Parallelism. Once you get used to look for parallelism options in your queries, and…

Read more

2 comments, 315 reads

Posted in Matan Yungman on 2 January 2014

T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks

This post is for T-SQL Tuesday #49, the monthly blog party of the community.

This tradition was started by Adam Machanic (blog | @AdamMachanic), and this month’s host is Robert David (blog | @SQLSoldier). This month’s topic is all about waits..

It’s Friday, Friday

It… Read more

6 comments, 594 reads

Posted in Matan Yungman on 10 December 2013

Interviews with Brent Ozar, Adam Machanic and Denny Cherry for SQL Server Radio

While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter) to the Israeli SQL Server Radio, the Podcast I co-host with Guy Glantser (blog | twitter Read more

0 comments, 199 reads

Posted in Matan Yungman on 9 December 2013

My SQLRally Experience

The past week I had the pleasure to attend SQLRally Amsterdam.

I took a flight from Tel-Aviv to Amsterdam and got there on Tuesday morning, which left me a whole day to get around the city. I traveled in the city center, ate a delicious pancake, drank a lot of… Read more

1 comments, 272 reads

Posted in Matan Yungman on 11 November 2013

Older posts