(Ron Peacock) Anyone who has worked with an Informix database knows that the moment you run into a query performance issue, you start with update statistics on that table. This was always what we were taught in support and talking with big names at IIUG, it’s still the best first step to take. The
Other News
RAC 12c enhancements: adding an additional SCAN-part 3
(Martin Bach) Travel time can be writing time and while sitting in the departure lounge waiting for my flight I use the opportunity to add part 3 of the series. In the previous two parts you could read how to add a second SCAN and the necessary infrastructure to the cluster.
Why using SQLTXPLAIN
(Carlos Sierra) Every so often I see on a distribution list a posting that starts like this: “I upgraded my application from database release X to release Y and now many queries are performing poorly, can you tell why?”
Unusable Indexes
(Andrew Reid) I tested this post on an Oracle 9 database. It shows that if you have an index which is marked as UNUSABLE, truncating the underlying table makes it VALID again.
White paper: IBM WebSphere MQ 7.5 versus Apache ActiveMQ 5.9
(Roman Kharkovski) This week Edison Group has published a new white paper comparing WebSphere MQ v7.5 and Apache ActiveMQ v5.9. While this report was commissioned by IBM, it was carried out independently by consultants of Edison Group in their own lab environment. Edison Group has spent three months
How column COLLATION can affect SQL Server query performance
(Ben Snaidero) Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to queryin
HOW TO: Restore the Master Database in SQL Server 2014
(Thomas LaRock) I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next.
How to Automate your Database Documentation
(Jonathan Hickford) In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment and post deployment validation of SQL Server databases using the command line versions of Red Gate tools. In this post I’m looking at another use for the
SQL SERVER – Merge Two Columns into a Single Column
(Pinal Dave) Here is a question which I have received from user yesterday.
Understand the ‘Heartbleed’ bug
In this white paper, Bipin Chandra examines the OpenSSL code in detail and explains how the bounds-checking error in the OpenSSL code created the “Heartbleed” memory leak. After reading Chandra’s explanation, you’ll understand the seriousness of the “Heartbleed” bug, and you will understand how to p