CDB Views and Query Optimizer Cardinality Estimations

Today I faced a performance problem caused by a bad cardinality estimation involving a CDB view in a 12.1.0.2 multitenant environment. While solving the problem I did a number of observations that I try to summarize in this blog post. First of all, when checking the execution plan of a query already running for more […]

Digital transformation is a phenomenon that is revolutionizing the tasks and activities we perform daily. Everything from news consumption to communication has been re-imagined and digitalized. End us ... Read more

Three times a week, John Savill tackles your most pressing IT questions. Today, he shares more about removing a dead Domain Controller from Windows Server 2016, manually installing System Center Endpo ... Read more

Interviews with Jann Horn and people who know him show how a combination of dogged determination and a powerful mind helped him stumble upon features and flaws that have been around for over a decade ... Read more

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension ... Read more

Recently during Comprehensive Database Performance Health Check, I had a very interesting conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty ... Read more

By now you’ve certainly heard of – or perhaps been impacted by – Meltdown and Spectre, two newly discovered vulnerabilities that affected nearly every modern processor. If not, you might w ... Read more

One of Microsoft’s Windows 10 goals has been to replace the legacy Windows 10 Control Panel with the new Windows Settings app. There has been consistent efforts in small areas for this project but tha ... Read more

The $1.7 billion of funding since 2010 is a bet that the industry’s rush into the Internet-of-things era will raise the risk of cyber-attacks on grids and demand for services that fight them. Read more

Editor’s Note: Jason Tseng attended a long-table discussion following a recent performance of Pillowtalk and provided the following response. Future long-tables will be held on January 18th and ... Read more

The 7th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative upda ... Read more

As smartphones and computers seep deeper into the fabric of everyday life, governments are looking at how they can use technology to improve life in cities while companies seek new ways to make money. Read more

In this final part of our Node-RED integration blog series, I will be covering how you can accelerate your website performance monitoring strategy by building a custom dashboard using the popular open ... Read more

As the Consumer Electronics Show was wrapping up its second day of four, I was heading out of town but not before I talked to a few more companies about their business-related products and services th ... Read more

Make Me Feed - Use RSS feeds technology to keep you informed about news relative hashtags that you use on the web, in this regard, all the site content are automatically inserted by reading third part feed. Makemefeed does not write articles.