Click here to monitor SSC
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.

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technology and make it faster and faster.

In a nutshell, as oppose to what we’re used to today, a Columnstore index keeps our data at the column-level… Read more

0 comments, 2,119 reads

Posted in Matan Yungman on 27 April 2016

How to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AG

You work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on the secondary server. How should you do that?

Scenario A: All databases are mirrored and should be accessed from the secondary

  1. Make sure the login(s) exists both on the primary…

Read more

2 comments, 32 reads

Posted in Matan Yungman on 3 March 2016

Things I learned in 2015

Happy 2016!

I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what I learned in 2013 and 2014). Here’s some of the things I learned in 2015.

Technical stuff:

  • Big Data is here, and it’s not only a buzzword or…

Read more

0 comments, 196 reads

Posted in Matan Yungman on 25 January 2016

How to Solve the Tail Insert Problem

In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s problematic.

In a nutshell, since traditionally we want our clustered index key to be narrow, static and ever-increasing, Identity is in many cases a very good choice. But since… Read more

1 comments, 242 reads

Posted in Matan Yungman on 19 January 2016

When Should You Use Identity as a Clustered Index Key?

A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be used as the clustered index key, and when it shouldn’t.

So first, starting SQL Server 2012, a Sequence is actually a better choice than identity. It’s more flexible, more… Read more

10 comments, 2,912 reads

Posted in Matan Yungman on 16 December 2015

My PASS Summit 2015 Recap

A few days ago I returned from PASS Summit 2015 (and a vacation I took afterwards).

Here’s my recap:

I opened the week with a FreeCon Brent Ozar and Kendra Little hosted.

The day focused on personal branding and the learning and sharing paths that are derived from it.

In… Read more

4 comments, 274 reads

Posted in Matan Yungman on 22 November 2015

Scripts and Slide Deck: The Data Loading Performance Presentation at PASS Summit

I have just finished delivering my session, The Data Loading Performance Presentation at PASS Summit 2015. It went very well, and I’d like to thanks anyone who attended.

Here’s a glimpse at the start of the session:

The scripts and slide deck can be downloaded from here.

Stay tuned… Read more

2 comments, 318 reads

Posted in Matan Yungman on 30 October 2015

Things You Need To Know about Nolock

Nolock is not the Satan, but no an angel too

Surfing the web you will find articles saying that Nolock is dangerous and shouldn’t be used, and articles stating that it’s THE solution for many problems. The truth, as in many cases, lies in the middle.

If you have a… Read more

0 comments, 209 reads

Posted in Matan Yungman on 26 October 2015

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):

Database Mirroring can work in Standard Edition

Database Mirroring is supported in both… Read more

5 comments, 835 reads

Posted in Matan Yungman on 24 September 2015

Speaking at SQLSaturday Oslo

This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.

I’ll be delivering a session I like a lot: The Data Loading Performance Presentation.

Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk… Read more

0 comments, 352 reads

Posted in Matan Yungman on 26 August 2015

Why You Should Care About Microsoft APS and Azure SQL Data Warehouse

Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and Azure SQL Data Warehouse.

The best way to learn about a subject is to teach it, and indeed, I learned a lot. Let’s talk about it a bit.

Architecture

APS… Read more

2 comments, 580 reads

Posted in Matan Yungman on 19 August 2015

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,383 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, 319 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, 214 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, 365 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, 397 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, 2,505 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:

CREATE TABLE LoadMeFast (Id INT NOT NULL, 
						InsertDate DATETIME NOT NULL, 
						ABunchOfLetters NVARCHAR(100)
						)
GO
SET NOCOUNT ON
GO
DECLARE @i INT = 1
WHILE @i <= 100000
BEGIN
	INSERT LoadMeFast SELECT @i, GETDATE(), REPLICATE(N'ABCD', 25)
	SET @i+=1
END
GO

The script runs for… Read more

10 comments, 3,524 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, 663 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

5 comments, 303 reads

Posted in Matan Yungman on 13 May 2015

Older posts