(Roman Rehak) A few months ago, I gave you an introduction to column-store indexes in SQL Server Denali, code name for the upcoming version of the database. Designed to improve query performance for data warehouse-sized tables, the column-store feature was not available in the first community techno
Other News
SQL Server and Distributed Transaction Tuning
(Kellyn Pot’Vin) Users complained that a monthly financial report would no longer run SQLServer Reporting Services, (SSRS.) Upon investigation, it was found that this was a stored procedure that ran from one Annex database, sourcing from another and outer joins to a SQLServer database on a remote
Using MySQL to Import and Retrieve Blobs and Display as Image Files in HTML
(Tony Darnell) I received a phone call from a friend of mine who had some questions about storing image files as blobs in MySQL. He wanted to design a web site that would allow someone to upload an image, and then that image would be stored in the MySQL database for viewing later.
DB2 10 and Prefetch
(Troy Coleman) DB2 10 makes it easier for customers to take advantage of prefetch. But before going into that, let me step back and define prefetch and explain its different types.
APAR Friday: WLM information is now part of the DISPLAY THREAD command
(Willie Favero) Yup, you are correct, today is not Friday; I’m missing that target by a few days. However, because I just discussed some workload manager (WLM) stuff in my previous post, this information just seemed like it should logically follow.
Social Sharing Buttons using jQuery and XML
(Bryian Tan) Yet another social sharing buttons script created by using jQuery and XML for your website. The script is very straight forward and self explanatory. The buttons container and buttons setting are stored in the XML file.
Configure and monitor InfoSphere Warehouse with Optim Performance Manager Extended Insight
(Michal Bodziony) Optim Performance Manager Extended Edition provides end-to-end database transaction response time monitoring capability for IBM® InfoSphere® Warehouse applications with its Extended Insight capability.
Creating Trellis Charts to Make SSRS Reports More Readable
(Siddharth Mehta) Factual data is generally analyzed from a lot of different dimensions. Because of this Grid based reporting is not an ideal reporting format to support analytical needs. Visual data representation like charts, graphs, and gauges are one of the best ways to report data that require
MapReduce A Key to NoSQL Performance
MapReduce – A Key to NoSQL Performance If you have been following the trend of my editorials these last few weeks, it will all start to come together today. While NoSQL and MapReduce are not necessarily linked, they are often combined to increase performance. MapReduce is a pattern allowing large chunks of data to be broken up into smaller chunks […]
NoSQL Data Stores, Readers Want More
NoSQL Data Stores, Readers Want More First a little housekeeping. I think it’s interesting that many of the newer data storage engines are labeled as “NoSQL”. Before these engines came along there have been a number of highly successful NoSQL databases that are difficult to beat for performance. For example, IDMS or CMS running on the IBM Mainframe platform has […]