For most DBAs, Management Studio is the primary work tool. That’s why properly using it can save a-lot of time and effort. Here’s a few...

Or Using SQL Server 2012 Offset Functions to Detect Gaps In Your Data Today we are going to examine date island problems and the ways in...

I came across a cool open source tool called “SQL Space Map“. The tool, written by Ryan McCauley, presents a visual representation of...

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

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