(Willie Favero) Today’s post is kind of cool because it transcends multiple versions of DB2 starting back in DB2 Version 5 with improvements added in DB2 versions 8 and 9. Each of these versions has made a contribution to the probability of a better access path through the use of the REOPT keyword.
Other News
Oracle Configuration Manager: Bane or Blessing?
(Mark Brinsmead) I’m not sure how long this has been out there, but there is a new (to me) headline on Oracle’s support website, announcing that next month, they will be phasing out “manual configuration” information for service requests.
A look at MySQL on ZFS
(John David Duncan) When Sun Microsystems released the ZFS filesystem in 2004, they set out to remove all of the practical limits on filesystem storage, and to make the arcane details of storage management a thing of the past. ZFS is a 128-bit filesystem with – to name just a few features – copy-on-
Cross-Page Postbacks Made Easy with .NET 2.0
(Shaun Eutsey) New technology is wonderful. I love going into things and looking at the nuts and bolts and figuring out how things work. This has led my wife to many hours of despair as I have tried to “fix” things that were not working too well. One thing was guaranteed, after it has been “fixed,”
Efficiently Uploading Large Files via Streaming
(Dina Fleet Berry) When uploading a file to a web server, the upload process generally requires the incoming file to be stored in memory until the upload is complete. If an uploaded file is larger than the available memory, memory usage in general and performance in particular will suffer.
Security in Oracle ADF and Automatic Page Loading
(Andrejus Baranovskis) In enterprise applications, automatic page loading based on user role is used quite often. Automatic page load is done during user login phase. This means that when user with role A enters into system, page X will be opened for him. And in the same way, when user with role B e
Create shortcut menus for forms in VB.NET using ContextMenuStrip
(Irina Medvinskaya) In order to implement shortcut menus for a form, you can add the VB.NET ContextMenuStrip control to your form. In the design mode, the control will appear on the bottom of the form. When you click the control, you can add menu items to it.
JSON-Enabled WCF Services in ASP.NET 3.5
(Dino Esposito) AJAX applications written for the ASP.NET platform work by sending HTTP requests to a server-side back-end. Aside from pages using the partial rendering engine – a sort of interceptor that uses XMLHttpRequest to place classic postbacks – an ASP.NET AJAX page requests data to a remote
Converting Access Queries to SQL Server
(Danny Lesandrini) In last month’s article, I introduced a Microsoft Access Add-In I created some years ago, which I affectionately call the DataFast Utility. It includes a number of analysis tools that assist with the process of upsizing an Access application to SQL Server. If all of your queries a
The GO command in SQL Server
The GO command in SQL Server is not a T-SQL command. It is a command that is recognized by the SQL Server utilities like osql or sqlcmd or the editors – Query Analyzer or SSMS. This just signals these utilities/editors to batch up the data and send it to the server. The batch comprises of all the