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.

Archives: March 2013

The Axis Of Evil

Views, table variables and local variables are great in terms of programming principles.

But In terms of performance, they can be a honey trap: They don’t scream “DANGER!” like cursors or user defined functions, but they can cause serious problems very easily.

That’s why I call them “The… Read more

5 comments, 2,699 reads

Posted in Matan Yungman on 20 March 2013

Do You Know sys.dm_exec_text_query_plan?

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 the Execution Plan for queries that are either currently running or have been cached.

For example, the following query will return the plan for queries that are currently… Read more

0 comments, 2,685 reads

Posted in Matan Yungman on 12 March 2013

On Trends And Proportions

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

Companies want to check what they can do with Hadoop, trying to understand what Big Data is and how it can generate more income. Big Data experts pop up on LinkedIn, newspapers… Read more

3 comments, 536 reads

Posted in Matan Yungman on 5 March 2013