(Dion Cho) One of my colleagues sent following test case, of which he couldn’t control the join order with hints.
Other News
Make huge space savings by using SPARSE columns
(Simon Sabin) I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years has shown that sparse columns a
Security in OBIEE 11g, Part 1
(Rob Reynolds) Continuing the series on OBIEE 11g, our guest blogger this week is Pravin Janardanam. Pravin has been working with OBIEE since his days with Siebel and is one of our top architects. In this two part series, he will be tackling the differences in security between OBIEE 11g and 10g, and
MySQL Partitioning – can save you or kill you
(Peter Zaitsev) I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions work internally.
The Web Application could not be found .verify that you have typed the URL correctly error: SharePoint 2010 object model
(Dhananjay Kumar) The below exception is very frustrating when we start working with SharePoint object model. Let us investigate how to solve below exception
Introduction to Facebook APIs
(C. Enrique Ortiz) You can incorporate Facebook functionality into your own applications. From the mobile perspective, the Facebook Platform supports APIs for mobile web applications, and mobile SDKs for native mobile applications for the iPhone, iPad, and Android platforms. In this article, explore
Introducing SYSPROC.ADMIN_INFO_SQL
(Michael Schenker and Thomas Conrad) When you experience a problem with one of your IBM DB2 for z/OS queries that you need to report to IBM Software Support, the most critical step in resolving the problem is to capture the query environment, which includes tables, indexes, views, statistics, EXPLAI
dbForge Data Studio for SQL Server
Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) dbForge Data Studio for SQL Server While reading my email I came across an announcement from devart located at www.devart.com. They announced the release […]
Denali Includes Sequences
Featured White Paper(s) VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more) Featured Script admin script – change the SID of a login without loss of security settings To avoid problems with orphaned users when you need […]
Transclusion
(Norman Walsh) XML offers a number of transclusion mechanisms, some better supported than others. There are DTD mechanisms, there are general solutions like XInclude, and more language-specific solutions like DITA conref.