(Jeffrey McDaniel) In the P6 Reporting Database 3.1 and higher, type 2 slowly changing dimensions were added. These changes are captured in tables with the suffix _HD. In each of these tables there is a field called current_flag.
Author: SSWUG Research
Creating a Linked Server for Oracle in 64bit SQL Server
(davidbaxterbrowne) This post is a walkthrough of creating a Linked Server to Oracle from 64bit SQL Server. There’s lots of information on doing this on the web, but much of it is out-of-date.
jQuery: NIEM Parsing with jQuery – Part 1
(Joel Byford) This series of articles will look at how to leverage jQuery to access and manipulate NIEM-conformant XML payloads. The first article looks simply at the capability to access, parse and read the data contained in a nc:AddressFullText element, strip whitespace from it, and place it in a
MySQL Fabric – Sharding – Introduction
(Narayanan Venkateswaran) Enterprises often start with a single server setup.
Using Explicit Pattern Matching With ResourceMapper.cfc
(Ben Nadel) Last year, I released a ColdFusion component – ResourceMapper.cfc – that allows you to easily translate RESTful resource requests into a server-side event and a collection of URL parameters. Today, I added a small, but powerful feature that allows you to define custom regular expression
Query Execution at Blazing Speed
(Lester Knutsen and Mike Walker) IBM Informix Warehouse Accelerator (IWA) software integrates seamlessly into IBM Informix server and can make database queries faster by many orders of magnitude than ever before.
How to Compare PL/SQL and SQL in Oracle SQL Developer
(Jeff Smith) This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny.
‘How to series’ about MVC, jQuery, JSON, paging, mapRoute
(Rajkapoor M) Client side work has been very important because of large amounts of data in database systems. In classic ASP.NET with code-behind, the natural approach is coding most of the work in code-behind files using ASP.NET components.
Quick deadlock inspection in SQL Server
(Anuj Varma) Deadlocks occur when multiple processes (usually two) are trying to access the same resource. Sql Server decides – after a specified period of time – to terminate one of the processes – so the other can move forward. The terminated transaction is rolled back.
SQL Server 2012 Partitioned Index Compression Comparison
(Dallas Snider) What are the differences in space consumption for the SQL Server partitioned index compression options? What compression options are available in SQL Server? Check out this tip to learn more.