Archives: March 2013
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
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
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