(Chris Travers) Arrays in PostgreSQL are relatively well supported by the indexing engines of this RDBMS. There are a fair number of options however to be aware of and an understanding of how arrays are indexed is very helpful. Before going forward, please read my intro on arrays so that you under
Author: SSWUG Research
SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation
(Pinal Dave) Sometime I feel I know a lot about SQL Server and very next moment, I realize that honestly I do not know much about this product. Earlier today, I had similar moments. I was playing with few DMVs and suddenly I ended up on the DMV sys.dm_xe_map_values. There are only four columns and o
When does an Oracle process know it’s on Exadata?
(Frits Hoogland) When an Oracle process starts executing a query and needs to do a full segment scan, it needs to make a decision if it’s going to use ‘blockmode’, which is the normal way of working on non-Exadata Oracle databases, where blocks are read from disk and processed by the Oracle foregrou
How to Parse Nested XML using Sencha Touch 2 – Part2
(Suresh Kumar) This Post is the continuation of where we left in Part1, If you haven’t read, Please read first and continue reading this Post.
Data Studio Update Part 3
(Dean Compher) In this article I will provide examples of how to do a variety of day-to-day DBA activities in Data Studio. I will discus how to easily gather information about your database and even how to generate an entity/relationship data model diagram to visualize the schema. Examples include
SQL Server Analysis Services Period over Period Variance Analysis
(Scott Murray) Often when working with OLAP cubes, the main “access” point will be an Excel pivot table. While utilizing OLAP cubes, end users will frequently want to compare two values from different periods in order to quantify some variance analysis processes; however the creation of calculations
jQuery Slideshow for a selected folder
(drewman5150) Jon Raasch has an excellent article about using jQuery for a simple image slideshow on his blog (http://jonraasch.com/blog/a-simple-jquery-slideshow) and I’ve decided to expand on this by populating the images dynamically from a folder using code behind – this way you can keep your ima
Zip and Unzip Files Programmatically in C#
(Bipin Joshi) Most of us deal with Zip files on a daily basis. Normally people use some third-party utility to create, open and extract Zip files. At times you may want to deal with Zip files programmatically. Luckily, .NET framework 4.5 introduces some new classes in System.IO.Compression namespace
DB2 10 and DB2 9 for z/OS Product Publication refreshes for April 2013
(Willie Favero) The April 2013 product publication updates are now available. There were no updates for DB2 10 or DB2 9 for March 2013. The “almost new” tradition continues with the pub folk publishing documentation updates on a near monthly bases…..
Optimizer Cost Parameters
(Brian Diehl) There is nothing about query optimization that is ever black or white; just many, many shades of grey. This is the case with the two index-related database parameters: optimizer_index_cost_adj and optimizer_index_caching.