As an employee of a company that does exactly this sort of service (remote outsourced DBA) I can tell you the things you should be looking for are:

1.) A thorough...

Optimise for ad-hoc is turned on on this server already - but there is still a lot of single use plans in the cache - presumably these have all been...

Thanks Jonathan - I think on average I learn something new for every 5 words you write when you respond to something.

I don't know if that's purely you being a...

Thanks for all the comments guys - after they applied CU6 a couple of days ago I'm seeing PLE consistently at 1.5 hours, the buffer pool is no longer using...

Thanks guys - I had recommended that they apply the latest CU and I believe they applied CU6 last night. I'm on-site next at that client tomorrow so I'll check...

Thanks for the feedback all - my first article so it's certainly a learning experience.

I haven't had a chance to play with 2014 yet - hopefully getting to that in...

Submitted - fingers crossed my first attempt at a public piece of writing passes muster.

I have a routine I use regularly based on the DMVs to trace a blocking hierarchy which I'd be happy to share/explain.

Neither of those DBCC commands clear the DMV's - the session you are connected with has still done x logical reads and y physical reads, regardless of what has or...

Asking what to look at when a query is slow is a bit like asking what colour string to use to tie up a balloon - it highly depends on...

You can completely ignore my post.

I just noticed that the script was setting the output variable FileName containing the file it found, and since my script wasn't working that wasn't...

I'm a bit confused about a couple of things in this article.

Firstly, you've defined a FileName variable of BusinessData.YYYYMMDD.xlsx which is implying that a file can arrive with a datestamped...