Αύγουστος 2012 - Δημοσιεύσεις
In this post I will be demonstrating with hands-on examples how to optimise your SQL Server for “ad hoc workloads“. I will be using the view LookIntoPlanCache that I created in this post .Make sure to read this post if you are not familiar with terms
Διαβάστε περισσότερα
In this post I will be demonstrating with hands-on examples how to look into the contents of Plan Cache. I will be explaining what the Plan Cache (Procedure Cache) is, the process of query optimization and the generation of execution plans in detail.
Διαβάστε περισσότερα
In this rather short post, I would like to talk about a very handy and easy to use tool (SQL Server 2012 Best Practices Analyzer-SBPA) that provides a lot of information about all the SQL Server 2012 components installed on the system and checks if the
Διαβάστε περισσότερα
A few weeks back, I received an email from a good colleague of mine that was really puzzled with the execution of a rather simple query.Finally he gave up and draw the conclusion that there was some sort of a bug in SQL Server.I tried this query myself
Διαβάστε περισσότερα
In this post I will be looking into a new feature in SQL Server 2012. Actually this is a T-SQL enhancement and it is called Query Paging.Often in our applications we need to page/select a number of rows (or a range of rows if you prefer) by specifying
Διαβάστε περισσότερα
In this post I will be looking into recompilation and stored procedures in SQL Server. More specifically I will show you why it happens,when it happens and the tools to identify recompilation of stored procedures.There are many reasons why a stored procedure
Διαβάστε περισσότερα