Discuss in the Community

Blogs

Deiby Gomez
Follow /24 Jul 2014 at 9:05am / Oracle

How to Know which Hub Node is used by a Leaf Node?

by Deiby Gómez After to read a lot of pages of Oracle Database 12c Documentation, Oracle Database 12c: HA New Features Student Guide and a RAC 12c Book I have found a lot of theory about Flex ASM and Flex Cluster which are two main new features...
7 0 /
Iggy Fernandez
Follow /24 Jul 2014 at 12:39am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 12: Throw Away that Execution Plan

Here's a little song I wrote You might want to sing it note for note: Don't worry be happy. In every life we have some trouble; When you worry you make it double. Don't worry, be happy. —Don’t Worry Be Happy by Bobby McFerrin...
94 0 /
Dinesh Asanka
Follow /23 Jul 2014 at 3:37pm / SQL Server

Cannot show the editor for this task.

I got this error in SSIS when I try to open Execute SQL Task. Then I tried to open already configured Execute SQL Task in some other SSIS packages. Still the error exists. I was wondering this is an error in SQL Server 2014 so I installed SQL Server 2012...
26 0 /
Sten Vesterli
Follow /23 Jul 2014 at 3:16pm / Oracle

New 12c feature: Imprecise answers

The Oracle database 12.1.0.2.0 is available for download and in addition to all the in-memory stuff Larry has been talking about, it has an interesting new feature: An approximate row count. The APPROX_COUNT_DISTINCT function "processes large...
69 0 /
Stuart Ainsworth
Follow /23 Jul 2014 at 3:00pm / SQL Server

Determining the Primary Key of a table without knowing it’s name

So, I’ve been trying to find more technical fodder for blog posts lately in order to get in the habit of blogging on a regular basis, so I thought I would explore a few of my higher-ranked answers on StackOverflow and provide a little more detail than...
27 0 /
Sten Vesterli
Follow /23 Jul 2014 at 1:29pm / Oracle

Blaming the Database

When an application performs poorly, most developers cannot possible imagine that the problem lies with the component they have developed. It has to lie somewhere else. But because developers don’t like blaming someone on their own team, the problem...
87 0 /
Kenneth Fisher
Follow /23 Jul 2014 at 1:00pm / SQL Server

Why am I getting a primary/unique key violation?

This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there may be more I don’t know) for seeing a primary key error. Technically they occur for any unique...
36 0 /
Rohit Garg
Follow /23 Jul 2014 at 10:33am / SQL Server

SQL Server 2012 with SP2 Slipstream ISO images fixed

Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are now available. Refer : http://support.microsoft.com/kb/2984316 Source...
45 0 /
Rohit Garg
Follow /23 Jul 2014 at 10:30am / SQL Server

Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !

The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
31 0 /
Syed Jaffar Hussain
Follow /23 Jul 2014 at 9:07am / Oracle

EID Holidays and things to do

Looking forward to a much anticipated 9 day EID holiday break to complete the to-do-list which I have been carrying for a while now. Determined to complete some of the writing assignments that I have kept pending for a long period of time now. At the...
38 0 /
Fernando Garcia
Follow /23 Jul 2014 at 12:10am / Oracle

Creando claves primarias con SYS_GUID

SYS_GUID es una función poco conocida. Cuando la invocamos genera y retorna un identificador único de 16 bytes. Oracle obtiene el valor a partir del identificador del host, el código de proceso que lo invoca y una secuencia que no...
87 0 /
SQLDBAPros
Follow /22 Jul 2014 at 10:26pm / SQL Server

Tuesday Tips: Test Backup and Recovery. Then Test Again.

DBAs aren’t doctors. Or firefighters, police officers or paramedics. But within the datacenter, a significant database loss could have a major impact on the life and death of a business. Not to mention, your job. While you probably have established...
107 0 /
Larry Leonard
Follow /22 Jul 2014 at 10:22pm / SQL Server

Quick Query to Display Database by Dataspace, Table, and Index

This query just breaks down the current database by dataspace, table, and index, giving you some useful information such as size in MB, pathname of the dataspace file, etc. -- Shows size of each object in each dataspace in the current database. select...
43 0 /
David Fitzjarrell
Follow /22 Jul 2014 at 9:27pm / Oracle

That’s … Huge!

Recently I’ve noticed the occasional thread in Oracle newsgroups and lists asking about hugepages support in Linux, including ‘best practices’ for hugepages configuration. This information is out on that ‘world-wide web’...
36 0 /
Dan Hotka
Follow /22 Jul 2014 at 7:10pm / Oracle

Use DBMS_XPLAN to generate Hints

Hi, Just another hinting blog. Got a problem SQL? Got it fixed? Want to maintain the current explain plan? Don’t want to deal with SQL profiles/SQL plan management? Answer is simple. Have the CBO tell you the hints needed to provide the...
47 0 /
Steven Feuerstein
Follow /22 Jul 2014 at 5:59pm / Oracle

Using LOG ERRORS as a testing mechanism

I recently heard a very interesting story about a use for LOG ERRORS : namely, to verify the correctness (and improve the performance) of a problematic SQL statement. I thought you might enjoy hearing about it. Greg Belliveau of Digital Motorworks buttonholed...
41 0 /
Natik Ameen
Follow /22 Jul 2014 at 5:46pm / Oracle

Oracle Database 12c Release 1 [12.1.0.2] Patch Released

Oracle 12.1.0.2 Patch 17694377 for Linux and Solaris has been released on Metalink and edelivery a few minutes ago. Happy upgrading! The post Oracle Database 12c Release 1 [12.1.0.2] Patch Released appeared first on VitalSoftTech .
44 0 /
Iggy Fernandez
Follow /22 Jul 2014 at 4:08pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 11: Abandon All Hope

“Through me the way among the people lost. All hope abandon, ye who enter in!” — Inscription on the gate of Hell from Divine Comedy by Dante Alighieri (14 th century) Previous installment: The story so far Next installment: Throw...
188 0 /
James Serra
Follow /22 Jul 2014 at 4:00pm / SQL Server

SQL Server Agent job steps vs SSIS

When doing ETL , you have the choice of using T-SQL or SSIS  (see When to use T-SQL or SSIS for ETL ).  If you decide T-SQL is the way to go and you just want to execute a bunch of T-SQL statements (individually or within a stored procedure), it’s still...
44 0 /
Dinesh Asanka
Follow /22 Jul 2014 at 2:42pm / SQL Server

Difference Between LEN and DATALENGTH

DATALENGTH - Returns the number of bytes used to represent any expression. LEN - Returns the number of characters of the specified string expression, excluding trailing blanks Output is 30, 3. Important point to remember is is LEN function does not depend...
75 0 /
Chris Webb
Follow /22 Jul 2014 at 9:30am / SQL Server

Working With Excel Named Ranges In Power Query

One of the more recent additions to Power Query is the ability to access data from named ranges in the Excel worksheet rather than an Excel table. I’ve got used to formatting data as tables in Excel because that’s what Power Pivot needs to import data...
46 0 /
Melissa Coates
Follow /22 Jul 2014 at 12:35am / SQL Server

Where to Find Q&A Optimizations in Power BI

Just a quick tip about where to locate the options in Power BI for doing Q&A optimizations. In the Power BI site, these are not where you might first think to look. What is Q&A? First, just a quick bit on what Q&A is and why you should care...
43 0 /
Steve Hilker
Follow /21 Jul 2014 at 11:59pm / Toad for IBM DB2

Toad for DB2 v6 - new interface

Did you notice that we've started a new beta program for Toad for DB2 ? If you can, you should give it a test drive. There are a lot of good changes in this next release. Here's a few of the highlights: User Interface Enhancement UI has...
33 0 /
rickdelgado
Follow /21 Jul 2014 at 10:11pm / NoSQL

The Basics of Cloud Computing Integration and Its Providers

It’s easy to say businesses should make cloud computing part of how they operate. After all, cloud computing can make companies more productive, more agile, and definitely more efficient. They’re the reasons so many businesses want to implement...
26 0 /
Mike Davis
Follow /21 Jul 2014 at 9:51pm / SQL Server

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the package will...
46 0 /