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...

Hi everyone! This month we released a new white paper for the newest SQL Server 2012 SP1 and Office 2013 authentication and identity delegation issues. Check this information at http://technet.microsoft.com/en-us/library/dn186184.aspx . Summary...

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 ...

Hi all, Last month, Microsoft’s Premier Education Services has released an ongoing series of online, on-demand trainings available to all Premier customers called the Premier TechTracks, of which there is a dedicated SQL Server track HERE . ...

Hi all, Just to share with the community that Ezequiel will be represented with several speakers at the upcoming SQL Saturday #188 , which will be hosted at the Microsoft Lx Experience building in Lisbon, Portugal.   Find more about the sessions...

Hello everyone, Last week I had a situation that was tricky to solve and involved Kerberos! At this time you are thinking: “Oh no, here comes big trouble!”. And you are right, it was difficult to understand what was happening but the...

Hello again, On my previous post , we covered how the Query Optimizer handles row estimation when using Table variables under specific conditions. Following up on that, I will demonstrate other scenarios where the Query Optimizer must try to optimize...

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...

Hello everyone, Today Data Quality Services (DQS) team release a post about upgrading DQS RTM to SQL Server 2012 SP1. Please refer to http://blogs.msdn.com/b/dqs/archive/2012/11/29/upgrading-dqs-to-sql-server-2012-service-pack-1-sp1-release.aspx...

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....

EDIT (12-04-2013): Added page type information (PFS; GAM or SGAM) when wait type is PAGELATCH_ or PAGEIOLATCH_ . EDIT (23-05-2013): Fixed parse page issue. Hello all, Following the series "SQL Swiss Army Knife", here is another version of this script...

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...

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...

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...

Hello all, If you follow this blog, this is another post on VLFs, a topic I’ve covered several times before. If you want to read more about it just click here . Also, all scripts in the VLF posts have been updated to support SQL server 2012....

Hello all, Just to give you the heads-up that Microsoft has made available a new free eBook entitled “ Introducing Microsoft SQL Server 2012 ”. Right now you can download the PDF version, but very soon an EPUB and MOBI versions will...

Hi all, That’s right, Ezequiel will be presenting 3 sessions in the upcoming SQLSaturday in Lisbon: “ SQL Server 2012 Extended Events ”, “ SQL Server 2012 SHOWPLAN - What's new? “ and " Exceed your business with Microsoft...

Hello all, Here is another one focusing on SQL scripts that may help on everyday DBA tasks, following the series "SQL Swiss Army Knife". This script will return, very promptly, the overall I/O statistics for all databases in your server, ordered...

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...

  Hello all, We would like to ask for your attention for the fact that there was a good refresh on the KB article related with Antivirus Guidelines for SQL Server (KB 309422 ).  Take some minutes to read it and to proceed according to the recommendations...

  Hi, Recently, SQLAzure Labs released two projects that could help, in different aspects, on the move, of our databases from the On-Premise stack to the SQLAzure world. The first project has the main purpose of helping on this move, performing a...

  Hello All, There are out there lots of information, already, about the SQL Server 2012 AlwaysOn feature. In resume, this feature is related with the enhancement of High Availability and Disaster Recovery capabilities available in SQL Server, at...

  Hello all, Don’t lose the opportunity to attend the SQL Server 2012 launch event! It will be online and to attend you just need to register yourself following the instructions available on the web address: http://www.sqlserverlaunch.com Cheers...

Hi all, Today I was looking for some information about PowerPivot configuration in SharePoint 2010 and found out this old post of Denny Lee from SQL CAT Team that explains the Security Architecture for PowerPivot. Sometimes is quite difficult to...

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...