Matan Yungman

The Axis Of Evil

• by Matan_Yungman

• Matan Yungman

Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be...

2013-03-25 (first published: 2013-03-20)

2,769 reads

Do You Know sys.dm_exec_text_query_plan?

• by Matan_Yungman

• Matan Yungman

One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...

2013-03-19 (first published: 2013-03-12)

2,730 reads

• Discuss

On Trends And Proportions

• by Matan_Yungman

• Matan Yungman

Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...

2013-03-05

551 reads

SQL Server Videos

• by Matan_Yungman

• Matan Yungman

About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want...

2013-02-26

1,041 reads

Things You Can Find In The Plan Cache

• by Matan_Yungman

• Matan Yungman

Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server...

2013-02-18

475 reads

SQL Server Podcasts

• by Matan_Yungman

• Matan Yungman

Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...

2013-02-14

1,550 reads

Querying Execution Plan XML For Inaccurate Row Count Estimates

• by Matan_Yungman

• Matan Yungman

I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...

2013-01-31

1,851 reads

What Queries From The Application Do To Your Plan Cache

• by Matan_Yungman

• Matan Yungman

Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query...

2013-01-09

1,167 reads

Small Changes Can Make A World Of Difference

• by Matan_Yungman

• Matan Yungman

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...

2012-09-30

1,111 reads

What I Expect From 24 Hours Of Pass

• by Matan_Yungman

• Matan Yungman

24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time.
I expect to:
Have little to no...

2012-09-19

523 reads