Subscribe to this blog
Archives: October 2011
Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from… Read more
9 comments, 2,059 reads
Posted in SQL Server Notes from the Field on 25 October 2011
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter and more efficient ways to do things – and that is spot on what I’ll do today.
Finding the time when SQL Server was last restarted, and using that… Read more
0 comments, 994 reads
Posted in SQL Server Notes from the Field on 18 October 2011
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM. RAM is faster and cheaper than IO capacity and RAM can reduce the pressure on the IO sub system.
Let’s see if we can write some diagnostic queries that can… Read more
0 comments, 225 reads
Posted in SQL Server Notes from the Field on 11 October 2011
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided by SQL Server. This week I will show another one that can be used to see how often a given index has been used.
The DMV is this one:
select…
0 comments, 409 reads
Posted in SQL Server Notes from the Field on 4 October 2011