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

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

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

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

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

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

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

One of our customers is implementing a very large consolidation project in which they enable users to create their own databases through...

Last week I delivered a seminar in the Expert Days 2012 event by the name of “40 Things You didn’t Know About SQL Server”. The seminar...

Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply it on an identical table...