(Pinal Dave) You can find the difference between UNION and UNION ALL in the following posts Union vs. Union All – Which is better for performance?
Other News
Looking Ahead to Entity Framework 7
(Julie Lerman) Development of the next version of Entity Framework is well underway. I got my first glimpse of what the EF team was working on at TechEd North America 2014, when Program Manager Rowan Miller talked about the goals for Entity Framework 7 (EF7) and demonstrated some very early bits.
How to Safely Replicate UUID Values in MySQL
(Ike Walker) With MySQL replication, when using the UUID() function to insert or update values in your database you need to be careful to assure the UUIDs are replicated properly. This is primarily a problem in statement-based replication.
Custom ADF Application with New ADF 12c Alta UI
(Andrejus Baranovskis) I was inspired by recently published WorkBetter application with ADF 12c Alta UI demo (you can read more about Alta UI and download WorkBetter application from here – Oracle Alta UI). I have decided to create my own application, using the same guidelines as described by Alta U
Oracle 12c WITH inline PL/SQL
(Scott Wesley) I’ve been having a bit of a play with the Oracle 12c database over the past few days and I thought I’d mention a gotcha I encountered.
Can A Background Process Impact A Foreground Process And Its Database Time?
(Craig Shallahamer) Have you ever heard someone say, “Background processes do not impact foreground processes because they run in the background and in parallel with foreground processes.” I’ve heard this hundreds of times!
SharePoint + SQL Server AlwaysOn: Outage Troubleshooting
(Samuel Betts) So you have a SharePoint/SQL outage despite having SQL Server AlwaysOn configured, and you naturally want to know why. Event IDs 5586 and 6398 are flooding the SharePoint servers and you don’t know why. On the SharePoint servers in the application log you might see either this:
Getting Started with IBM InfoSphere Optim Workload Replay for DB2
(Whei-Jen Chen, Nisanti Mohanraj, Hassi Norlen, Leif Pedersen, Patrick Titzler, Tom Toomire and John Vonau) This IBM Redbooks publication will help you install, configure, and use IBM InfoSphere Optim Workload Replay (InfoSphere Workload Replay), a web-based tool that lets you capture real productio
jQuery Datatables For Beginners
(Mohammed Sadullah) In this tip, I’ll explain how to have basic HTML table features like Sorting, Searching, and Paging with just one line of code using jQuery DataTables as these features are a must have for all tables and grids.
The DB2Night Show z56: Must knows about Distributed access to DB2 for z/OS
(martin) 100% of our studio audience learned something!Cristian provided valuable tips and insight into distributed configuration, DBAT, and many other topics.