(Matthew Morris) Oracle Database tables with heavily fragmented data waste disk space and can result in moderate to severe performance implications. That is when Oracle segment space management, and in particular the Oracle Database segment shrink function, can help.
Author: SSWUG Research
PostgreSQL Functional Indexes
(Szymon Guz) PostgreSQL has got the great feature named “functional indexes”. A normal index just stores sorted values of some field. It is great for searching, as the values are already sorted.
The DB2Night Show z37: Application Tuning Revisited
(Martin) 100% of our studio audience learned something! Martin presented his approaches to application problem solving and tuning.
Red Alert Could Impact DB2 10 Users, z/OS 1.12 and 1.13 Releases
(Troy Coleman) This IBM Red Alert notification, “Potential loss of data for DB2 v10 users on z/OS 1.12 and 1.13 releases,” is dated May 29:
Part 3–Getting start with Statistics for Oracle Data Science projects
(Brendan Tierney) This is the Part 3 blog post on getting started with Statistics for Oracle Data Science projects.
Sorting Out Constraints
(dfitzjarrell) An interesting question was posed on the Oracle-L list a while back; a member was having difficulty getting a constraint created using an existing non-unique index as Oracle would consistently consume all of the TEMP space and cause the process to terminate for lack of resources.
Jdom 2 Xml Parser – Read xml and Create xml in Java
(Ankush Thakur) Jdom is the most developer friendly XML parser to read and create an xml file in Java. Jdom’s programming friendly nature provides mechanism and implementation that makes it easy to xml parsing for java developers. JDOM uses one of the two mechanism, DOM or SAX to parse an xml but us
CTE Scope
(Steve Stedman) Day 5 of Common Table Expression Month (June) at SteveStedman.com, today I will cover concepts around the scope of a CTE.
Avoiding Parameter Sniffing in SQL Server
(Dinesh Asanka) Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.
Using PowerShell to access event logs for SQL Server
(Manvendra Singh) This tip will introduce a few PowerShell cmdlets related to accessing and handling Windows event logs. The event logs capture various system events that occur for both Windows and specific applications like SQL Server. If anything goes wrong with your SQL Server box then the even