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

by Matan_Yungman

Matan Yungman

A client called us with the following issue:
He had a table of a few dozen million rows. The table had...

2015-08-03 (first published: 2015-07-27)

2,739 reads

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

by Matan_Yungman

Matan Yungman

Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The...

2015-07-24

547 reads

Speaking about Columnstore Indexes at PASS Performance Palooza

by Matan_Yungman

Matan Yungman

The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance...

2015-07-21

481 reads

Can a SQL Server Table be Too Small?

by Matan_Yungman

Matan Yungman

Everyone’s talking about “Big Data”, huge tables and data explosion right?
Can we have a problem of a table that is...

2015-06-26 (first published: 2015-06-16)

3,504 reads

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

by Matan_Yungman

Matan Yungman

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

2015-06-25

658 reads

Speaking at 24 Hours of PASS: Growing Our Community

by Matan_Yungman

Matan Yungman

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

2015-06-18

550 reads

The #1 Enemy of Data Loading in SQL Server

by Matan_Yungman

Matan Yungman

Let’s look at the following script:
CREATE TABLE LoadMeFast (Id INT NOT NULL,
InsertDate DATETIME NOT NULL,
ABunchOfLetters NVARCHAR(100)
)
GO
SET NOCOUNT ON
GO
DECLARE...

2015-06-09 (first published: 2015-06-03)

4,055 reads