I’m aware that in the previous article in this series I said I’d continue “in a few days” and it has now been more like 11 weeks – but finally I’ve got the time. In this article I’m going to talk primarily about Bloom filters and their impact on performance, but I’ll need to say something about the “virtual tables” and “parallel execution message size” before I begin. Take a look at this fragment of a parallel execution plan:
Common internet question: does the order of predicates in the where clause make a difference.
General answer: It shouldn’t, but sometimes it will thanks to defects in the optimizer.
Operating through an on-premise data center is gradually becoming less attractive to company executives constantly bombarded with sentiments praising the operational capabilities of the cloud. As a result, many are considering making the transition to the environment, but lack the resources required to do so.
This note describes the process of configuring a initial data load job as well as Change Data Capture from an Oracle 12c pluggable database source and a MS SQL Server 2012 target database.
Download the note here ….
Business leaders who have dabbled in bring-your-own-device and mobile device management strategies are well aware of the powerful benefits afforded by the technology, but few have taken full advantage of the movement due to shaky employee compliance, a lack of dedicated software and a host of IT security concerns.
Do you ever click on a bookmark to find that the website is no longer available? That scenario was the inspiration for my first post. I was posed a question regarding setting up maintenance tasks for SQL Server Express Edition and my bookmark no longer worked. Luckily, I already had a local copy of the script and its usage, but I wanted to ensure that the solution can be easily found by others.