SQL Clone
SQLServerCentral is supported by Redgate
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.

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:

He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed.

He had an ETL process that inserted a few thousand rows every few minutes. When the table had only a… Read more

7 comments, 2,656 reads

Posted in Matan Yungman on 27 July 2015

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.

I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.

The recording is already up:


The scripts and slide deck can be downloaded from here.

The post Columnstore Indexes at PASS Performance Palooza: Recording and Materials Read more

0 comments, 497 reads

Posted in Matan Yungman on 24 July 2015

Speaking about Columnstore Indexes at PASS Performance Palooza

The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great speakers from all around the world.

I have the honor to speak in this year’s Performance Palooza, which will take place this Thursday, July 23.

I… Read more

0 comments, 418 reads

Posted in Matan Yungman on 21 July 2015

24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.

It was a lot of fun taking part in such a special event.

The slide deck and scripts I used in the session can be downloaded here.

The post 24 Hours of PASS:… Read more

0 comments, 549 reads

Posted in Matan Yungman on 25 June 2015

Speaking at 24 Hours of PASS: Growing Our Community

24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking there.

24 Hours of PASS is a virtual event of 24 consecutive hourly sessions of speakers from all over the world. The theme this time is “growing our community”, and… Read more

0 comments, 512 reads

Posted in Matan Yungman on 18 June 2015

Can a SQL Server Table be Too Small?

Everyone’s talking about “Big Data”, huge tables and data explosion right?

Can we have a problem of a table that is too small?

Imagine you have a very small table (up to a few thousand rows) that fits into a single SQL Server page, being constantly read and updated, and… Read more

1 comments, 3,016 reads

Posted in Matan Yungman on 16 June 2015

The #1 Enemy of Data Loading in SQL Server

Let’s look at the following script:

						InsertDate DATETIME NOT NULL, 
						ABunchOfLetters NVARCHAR(100)
WHILE @i <= 100000
	SET @i+=1

The script runs for… Read more

10 comments, 3,964 reads

Posted in Matan Yungman on 3 June 2015

Query Progress Tracking in SQL Server for the DBA VC

This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.

The session covers many techniques for tracking the progress of queries and processes. I also talked about very nice features that were added in SQL Server 2014 and SQL Server 2016.

The… Read more

0 comments, 1,156 reads

Posted in Matan Yungman on 29 May 2015

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

6 comments, 432 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

5 comments, 5,129 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, 974 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, 6,639 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, 539 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, 554 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, 385 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, 464 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, 488 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, 654 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, 5,400 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

7 comments, 7,359 reads

Posted in Matan Yungman on 6 November 2014

Newer posts

Older posts