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.

How to Find Objects that Contain a Certain String in SQL Server

Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t remember in which stored procedure you saw it.

The following script searches for a certain string inside the code of all programmatic objects in the database (stored procedures, triggers, views… Read more

4 comments, 140 reads

Posted in Matan Yungman on 13 May 2015

Make Sure to Schedule Your SQL Server Replication Jobs

You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.

Right? Wrong..

At some point in time, your replication jobs will stop (some replication failure, stop for maintenance, etc..). Once that happens, will they start working again?

When you… Read more

2 comments, 4,437 reads

Posted in Matan Yungman on 22 April 2015

How to Measure IO Latency for Database Files in SQL Server

In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called sys.dm_io_virtual_file_stats.

In addition to information about number of reads and writes, and the amounts of bytes read and written, we also have the io_stall_read_ms, io_stall_write_ms and io_stall, which… Read more

0 comments, 172 reads

Posted in Matan Yungman on 8 April 2015

Can Log Shipping Work Without Shipping the Log?

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:

Backup: Performs a backup log operation on the primary server, logs history and deletes old backup files and history information

Copy: Copies the backup files to the secondary server and logs history

Restore: Restores… Read more

0 comments, 5,787 reads

Posted in Matan Yungman on 30 March 2015

SQLRally and SQLBits Slides and Demos

It’s been a great a busy week.

On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

On Thursday, I presented my session, “The Data Loading Performance Presentation”, at SQLBits in London.

Thanks to everyone who attended my sessions. I had a lot of… Read more

0 comments, 194 reads

Posted in Matan Yungman on 6 March 2015

How to Fix Latch Problems when Working with Ascending Keys in SQL Server

Traditionally, we want our Clustered Index to have the following attributes:

  • Narrow: So that our clustered index and the non-clustered indexes that point to it will be as slim as possible
  • Static: So that we don’t generate fragmentation in the clustered index and we don’t have to update the non-clustered…

Read more

0 comments, 179 reads

Posted in Matan Yungman on 3 March 2015

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun.


On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

The session talks about a big… Read more

0 comments, 120 reads

Posted in Matan Yungman on 24 February 2015

The Data Loading Performance Presentation

This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.

I worked on the session a lot, and delivering it was tons of fun.

The session talks about the ways to load big amounts of data fast, and about the enemies that can make… Read more

0 comments, 176 reads

Posted in Matan Yungman on 21 January 2015

What to Expect When Transitioning from DBA to Consultant

Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning from being a DBA to being a consultant.

We had a great conversation and covered a lot of issues. Among… Read more

2 comments, 161 reads

Posted in Matan Yungman on 15 January 2015

Things I Learned in 2014

2015 is here!

Last year I wrote about what I had learned in 2013, and I try to make it a tradition. So without further ado, here’s what I learned in 2014:

SQL Server

  • Columnstore Indexes are amazing. The Columnstore technology is fascinating to me, and I keep learning…

Read more

0 comments, 194 reads

Posted in Matan Yungman on 6 January 2015

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

5 comments, 4,584 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,447 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, 433 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

10 comments, 6,641 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, 260 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, 255 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, and we love it.… Read more

0 comments, 777 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, 624 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, 127 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, 117 reads

Posted in Matan Yungman on 17 July 2014

Older posts