Blog do Ezequiel
Portuguese PFE SQL Server Team


Latest Updates
13/01/2014 - Latest update on the AdaptiveIndexDefrag procedure v1.5.7. Look for it in the "Ezequiel shortcuts" section on the right or just click HERE.

18/02/2014 - Updates to Maintenance plan deployment scripts available HERE

16/04/2014 - The SQL Swiss Army Knife Series Index
  • Blog do Ezequiel

    T-SQL Misconceptions - JOIN ON vs. WHERE

    • 3 Comments
    Hello all, Last week while I was onsite, I was discussing with a customer about some T-SQL querying misconceptions, one particularly caught his interest. In the subject of JOINs , I was asked if there are there any known issues using search arguments...
  • Blog do Ezequiel

    How to integrate SSRS Reports with PerformancePoint Dashboards in SharePoint 2010

    • 4 Comments
    Hello all, Probably a few of you have heard about PerformancePoint in Microsoft’s BI stack. PerformancePoint Services is set of tools and services that allow you to create and publish Business Intelligence Dashboards in SharePoint 2010. PerformancePoint...
  • Blog do Ezequiel

    Best Practices on FILESTREAM implementations

    • 3 Comments
    Hello all, Recently I was asked to advise a customer on a FILESTREAM implementation he was devising, and part of that ended up becoming this blog post that I hope can be of some help for you. When to use FILESTREAM? In SQL Server, BLOBs can be...
  • Blog do Ezequiel

    Adaptive Index Defrag

    • 7 Comments

    The purpose for this procedure to to perform an intelligent defrag on one or more indexes for one or more databases. The 1st release was inspired by an earlier release of Michelle Ufford’s code in SQLFOOL.com site, and has since evolved to suit different and added needs. In a nutshell, this procedure automatically chooses whether to rebuild or reorganize an index according to its fragmentation level, amongst other parameters, like if page locks are allowed or the existence of LOBs.
    All within a specified time frame you choose, defaulting to 8 hours. The defrag priority can also be set, either on size, fragmentation level or index usage (based on range scan count), which is the default.
    It also handles partitioned indexes, optional statistics update (table-wide or only those related to indexes), rebuilding with the original fill factor or index padding and online operations, to name a few options.

    ...
  • Blog do Ezequiel

    About Maintenance Plans – grooming SQL Server

    • 12 Comments
    Hello all, I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I wrote and keep updating the AdaptiveIndexDefrag procedure....
  • Blog do Ezequiel

    Take most of Reporting Services Logs with Excel 2013

    • 1 Comments
    Hi everybody. It’s been a while since I have posted in this blog about Reporting Services Logs and today we are going to put some of it in practice. The purpose of this post is to use the newest version of Excel 2013 Customer Preview that...
  • Blog do Ezequiel

    SQL Best Practices for MOSS

    • 1 Comments
    Hello all, One question that arises often is how can we correctly configure SQL Server to work with MOSS?. Although the majority of best practices for SQL does apply, there are some diferences that it is important to be aware of. 1 - Architecture...
  • Blog do Ezequiel

    SQL Server and Log File usage

    • 1 Comments
    Hello all, I decided to talk about an issue I've recently dug a little deeper, and so i will talk about how and why Log files (and their growth strategy) affect recovery times, mirroring, replication, large data changes (batches), leads to disk fragmentation...
  • Blog do Ezequiel

    Table variables and row estimations – Part 1

    • 0 Comments
    Hello all, The subject of estimated rows vs. actual rows in plan execution has a lot of impact in query performance, and the source of these skews can be quite diverse, from outdated statistics, to incorrect sampling, or the inability of the query...
  • Blog do Ezequiel

    PAGELATCH_EX waits and heavy inserts

    • 8 Comments
    Hello all, Recently I came across an issue over a table that was being inserted into quite intensively, by concurrent operations. The issue, which is not that uncommon, is dealing with PAGELATCH _EX contention, namely when a table has a clustering...
  • Blog do Ezequiel

    SQL Server 2012 RC0 Released

    • 3 Comments
    Hello all, Just to share with you a summary with the news, publicly available, about SQL Server 2012 RC:   Technorati Tags: SQL Server 2012 RC0 , What's new   Official Release Information            ...
  • Blog do Ezequiel

    How to script all my database objects? Here is the answer.

    • 2 Comments
    One question that sometimes arises is "How can we script all database objects throught some kind of automation?" You have several ways to do it. For both SQL 2000 and SQL 2005 you have Microsoft SQL Server Database Publishing Wizard that generates...
  • Blog do Ezequiel

    The SQL Swiss Army Knife #1 - Scripting Securables - Updated

    • 3 Comments

    EDIT (11-01-2013):  Fixed issue with generating all logins even when single database was chosen.

    Hello all,

    I've recently joined the PFE team in Portugal, and one part of the job i like is giving something back to the community.
    Whenever possible, i will be focusing my posts on SQL scripts that may help on everyday DBA tasks, something in the likes of a "SQL Swiss Army Knife".
    According to BOL, SQL securables "are the resources to which the SQL Server Database Engine authorization system regulates access".

    ...
  • Blog do Ezequiel

    SQL Swiss Army Knife Series is indexed

    • 3 Comments
    Hello all, By popular demand, I’m creating this post to serve as the central location for all past and future posts of the “SQL Swiss Army Knife” series, which should also make it easier to find and new updates. Tag ...
  • Blog do Ezequiel

    SQL Server - Performance Counters, Thresholds, etc.

    • 2 Comments
    These are normal questions: What counters should I select to monitor my SQL Server instance? What thresholds or values should I use to know when something bad is happening? Use this webcast to get answers: TechNet Webcast: SQL...
  • Blog do Ezequiel

    Auto Update Statistics Asynch - Are you really, really using it?

    • 0 Comments
    Hello all, It’s been awhile since I’ve updated the blog from my part. It’s been a rough month, and I’ve been on vacation prior to that, but I’m back. What I want to get your attention in this post is to the “Auto...
  • Blog do Ezequiel

    SQL Server vNext – Codename “Denali” and much more …

    • 1 Comments
    Hello all, This week it was announced the first CTP of the next version of SQL Server (Codename “Denali”) and the 1st Release of SQL Server Parallel Data Warehousing (PDW) at SQLPASS, Seattle. On the following table you can find a resume of the new features...
  • Blog do Ezequiel

    SQL Swiss Army Knife #9 - Fixing VLFs

    • 4 Comments
    EDIT (09-08-2011): missing variable set for sql version. Thanks go to Calvin for finding this bug. EDIT (26-03-2012): Updated script for SQL 2012 support. EDIT (19-09-2012): Simplified logic. EDIT (20-09-2012): Changed grow settings if not SQL...
  • Blog do Ezequiel

    SQL Swiss Army Knife #12 - Index information galore!

    • 3 Comments
    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...
  • Blog do Ezequiel

    The SQL Swiss Army Knife #5 - Checking Autogrow times

    • 5 Comments

    Hello all,
    Here is another one focusing on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". This time we are exploring an alternative way of verifying autogrow times besides checking the ErrorLog for any recorded information, and that is when an error 5144 or 5145 occurs.

    ...
  • Blog do Ezequiel

    CPU Drift and SQL Server timing values

    • 1 Comments
    We recently had an issue on a 2 node SQL cluster that led us to take profile traces. Soon we realized that some timing values from the traces didn't make sense. After some research we turned to this: SQL Server timing values may be incorrect when you...
  • Blog do Ezequiel

    How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)

    • 0 Comments
    Hello, In the past I posted the new SharePoint SP1 features for PerformancePoint Services which included the new cascading filters option. In this post, I’m going to show you the basic steps to achieve this goal with Dashboard Designer in SharePoint...
  • Blog do Ezequiel

    Can log files growth affect DML?

    • 8 Comments

    Hello all,

    A while back I blogged here about how a good strategy of log file growth could potentially impact ongoing operations with your SQL Server. It’s known that VLFs (number and size) impact on the performance of such actions as scanning all VLFs for transactions that are marked for replication or log backup operations. Following that blog post, I became curious as to how having a poor strategy could potentially impact some less than obvious operations within SQL Server and decided to put that to a test..

    ...
  • Blog do Ezequiel

    SQL Server 2008 R2 – New White Papers

    • 3 Comments
    Hello all, New white-papers were released: SQL Server 2008 R2 Upgrade Technical Reference Guide – Link . SQL Server 2008 R2 Security Best Practices – Link . Cheers,
  • Blog do Ezequiel

    The “rumor” is true: SQL Server 2012 has a new high VLFs warning (Edited).

    • 1 Comments
    Hello all, If you follow this blog, you know I blogged on VLFs several times before and if you want to read more about it just click here . I decided to investigate a bit on something Kalen Delaney mentioned today in a SQL PASS session. She heard...
Page 1 of 5 (108 items) 12345