Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: A practical example on missing a filtered index

    Hello all, Last week I did a brief presentation on SQLPort about hinting the database engine. What’s related here is that during the presentation, when I was discussing index hints, an attendee asked me about the usefulness of Filtered Indexes in certain scenarios, and how the database engine would behave...
  • Blog Post: SQL Swiss Army Knife #12 - Index information galore!

    EDIT (06/06/2012): Added script for all databases (may cause performance problems in large servers) and current database only. also fixed issue with partition aligned indexes. EDIT (19/11/2012): Added Heap information and redesigned duplicate and redundant index search. EDIT (18/12/2012): Fixed...
  • Blog Post: A case of seeks and scans

    Hello all, A couple weeks ago while I was onsite, I was looking at some queries that had performance issues. To the customer, one in particular had become a conundrum that could not be easily answered with the usual approach of good indexing, simply because there was already a good covering index...
  • Blog Post: Adaptive Index Defrag

    Hello all, because the procedure usp_AdaptiveIndexDefrag has undergone a few more updates, starting now this post will be the only source of information for it, including a full change log at the end of this post . It’s also reachable from the links section on the right anywhere on the blog. ...
  • Blog Post: SQL Swiss Army Knife #7 - Adaptive Index Defrag

    Hello all, Sorry for the inconvenience, but the content of this post moved to the Adaptive Index Defrag post .
Page 1 of 1 (7 items)