When do conversions generate conversion warnings? And why are these bad?

Hello, A few days ago a colleague asked me why was he seeing implicit conversions in the execution plan, but no warnings of such sort were being issued. Warnings are seen in the plan if the conditions they affect occur, and then are surfaced in the <Warnings> element of SHOWPLAN, either as affecting Cardinality Estimates…

0

SQL Swiss Army Knife #15 – Handling duplicate indexes

Hello all, Part of my job is to help customers find and fix performance issues, and this post comes after one such engagement. A customer was using another of the SQL Swiss Army Knife series scripts to find info on indexes on all the databases in a given instance – the one referenced in the…

0

Have you heard of the EPM Framework?

EPM stands for Enterprise Policy Management, and it’s a framework designed with the objective of allowing a scalable use of PBM (Policy Based Management) feature. Also, I’m writing this post because the EPM Framework was just updated to v4. Sometimes overlooked, PBM is an excellent tool for any DBA to keep track of any standards…

1

MDS 2012/2014: Where my soft deletes at?

  In Master Data Services, a soft delete is the result of removing a member via the MDS UI or the Excel add-in. What this means is that the member isn’t actually deleted, it’s just a new state that the record acquires. This mechanism allows the recovering of a certain member by reverting the transaction…

0

Too many single use plans, now what?

Hello, I’ve been asked the question in title at least twice in the past month, but the question is really incomplete – I would rather be asked “I have too many single use plans taking up a lot of memory in my server, can I do something about it?”. The answer would be the classic…


Beam me up, Azure!

I’ve decided that my next VM (hosting SQL Server 2014) was going to be built in Azure, taking advantage of my MSDN subscription and using “my” SQL Server bits as well. If you have a MSDN subscription you should really take advantage of this and perhaps host those in-house projects and give them another life,…


SQL Swiss Army Knife #14 – Troubleshooting with Waits and Latches

EDIT (30-04-2014): Detailed categorization of memory related waits Hello, The topic of Waits and Latches is quite well documented around the web, and there are several nice references that I list further down. Suffice to say that SQL Server waits, specifically threads that are executed have to wait for resource availability to carry on its work,…


SQL Swiss Army Knife #13 – Exploring the plan cache – Part 2

Hello all, This is long overdue, but here it is, the follow up on plan cache exploration queries part 1 post. There are many “hidden” gems inside a query plan XML that allow us to know our workloads in greater and better detail. Here are a few more xqueries snippets for various purposes. These are…