-->
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.

Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution

In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution flow for running queries, and how to watch the live execution plan for all queries using the lightweight profiling feature of SQL Server 2016 SP1:

 

The post Video: How… Read more

0 comments, 780 reads

Posted in Matan Yungman on 3 May 2017

SQL Server 2016 for Performance Tuning Lovers

Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of fun and actually felt more like a bunch of guys hanging out and drinking a beer than a training event.

I talked about live SQL Server 2016 gems… Read more

0 comments, 163 reads

Posted in Matan Yungman on 2 May 2017

T-SQL Programming for Developers Course

Are you a software developer?

Did you ever get to develop a software that works with a Microsoft SQL Server database?

Perhaps you started out all nice and good, seeing how well and easy SQL Server works, but then with time, as your software grew and you collected more and… Read more

0 comments, 490 reads

Posted in Matan Yungman on 13 March 2017

Datediff: We’ve Been Doing It Wrong

One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of those is the use of the Datediff function for retrieving the rows from the last x minutes/hours/days and so on.

Let’s look at the following… Read more

0 comments, 279 reads

Posted in Matan Yungman on 23 January 2017

Performance-Oriented SQL Server Development – The Scripts

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.

It was a great experience, and I’d like to thank everyone who attended.

The scripts from the seminar can be downloaded from here.

 

 

The post Performance-Oriented SQL Server Development –… Read more

0 comments, 410 reads

Posted in Matan Yungman on 30 December 2016

Performance-Oriented T-SQL Development in Belgium

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s for a pre-conference session.

This full day seminar is called Performance-Oriented T-SQL Development, and it will focus on solving real world problems… Read more

0 comments, 95 reads

Posted in Matan Yungman on 29 September 2016

If You Need to Think, You’re Doing It Wrong

A month ago, my wife and I were in Barcelona for a short vacation.

In one of the days, we entered a small place called Wok to Walk for dinner. The concept is simple: You build your dish by choosing your base (the type of noodles or rice), then your… Read more

0 comments, 127 reads

Posted in Matan Yungman on 29 June 2016

My PASS Summit 2016 Session Submissions Feedback

I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this year! The session is called “MongoDB for the SQL Server Professional”.

More about the session in the future. For now, after Brent Ozar and Steph Locke published their abstract review… Read more

1 comments, 58 reads

Posted in Matan Yungman on 24 June 2016

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, 3,070 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, 118 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, 322 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… Read more

1 comments, 446 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, 3,344 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, 413 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, 576 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, 342 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, 1,084 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, 554 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, 818 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,555 reads

Posted in Matan Yungman on 27 July 2015

Older posts