(Michael Sansoterra) In modern applications, it’s typical to store large amounts of text data, including emails, rich text documents, audit logs, and XML. Recording this information in a database table can impose a significant tax on disk space.
Author: SSWUG Research
Raster Words using PostGIS 2.1
(Leo Hsu and Regina Obe) Two of the big changes in PostGIS 2.1 raster are the improved speed and functionality of the raster ST_Union function and ST_Clip. Aside from speed, the big thing with ST_Union in 2.1 is that it applies operations to all bands by default.
Database Validation in Data Guard 12c
(Andrey Goryunov) DGMGRL was never difficult to use; however, it was not providing enough information before switchover/failover to make sure it happened without issues. Even if “show configuration verbose” was indicating that everything had the SUCCESS status, switchover could lead to issues during
Oracle12c: Session Data Unit(SDU)
(Shan Nawaz) Session Data Unit(SDU) is the session layer responsible for sending/receiving data from transport layer. See table below for OSI diagram. Generally increasing the value of SDU can result in improved performance, efficient network utilization when transmitting large amounts of data.
Oracle SQL Developer 4 Quick Hit: Search and Replace
(Jeff Smith) The new editor framework provides a more interactive and rich experience when replacing text. It’s a very simple improvement, but one that I think will make you feel ‘better.’ I know that’s a subjective measurement, but I’m sticking with it.
How to Handle a Huge Collection of Strings in VB.Net
(Reed Kimble) There are times when an application may require a very large index of strings for some specific purpose, and you desire the ability to search for strings that begin with given characters. A simple spell check, or syntax matching routine might want to check to see if each word entered
The effect of VLF size on shrinking the log.
(Kenneth Fisher) I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided to do a bit of experimentation.
New Enhanced Column Store Index in SQL Server 2014 – Part 1
(Arshad Ali) Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses c
40 jQuery Plugins to Make Your Website User Friendly
(Gavin McLeod) The basic function of a plugin is for it to perform an array of methods with a collection of elements. Each method which comes with the jQuery core such as a plugin, like .fadeOut() or .addClass() .
Fragment Caching in ASP.NET or How To Perform Fragment Caching in ASP.NET by Using VB.NET/C# or Fragment Caching Example, Page Fragment Caching in ASP.NET
(SaiRojaKishore) Hi friends, in this article I will explain about Fragment Caching in ASP.NET or How To Perform Fragment Caching in ASP.NET by Using VB.NET/C# or Fragment Caching Example, Page Fragment Caching in ASP.NET.