Discuss in the Community - Toad World

Discuss in the Community


Thomas LaRock
Follow /30 Nov 2015 at 3:09pm / SQL Server

SQL Server Identity Values Check

Very few users have any idea how many SQL Server identity values they have remaining on a column. The post SQL Server Identity Values Check appeared first on Thomas LaRock . If you liked this post then consider subscribing to the IS [NOT] NULL newsletter...
14 0 /
Dinesh Asanka
Follow /30 Nov 2015 at 2:04pm / SQL Server

How to Avoid CXPACKETs?

CXPACKET is one of the famous wait type that database administrators are experiencing. Before moving into the details of CXPACKET wait type, - See more at: http://www.sqlshack.com/how-to-avoid-cxpackets/#sthash.lnQI7Ouh.dpuf http://dbfriend.blogspot.com...
21 0 /
Kenneth Fisher
Follow /30 Nov 2015 at 2:00pm / SQL Server

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus? The situation User : Oh noes! The web sites down! One quick call later Developer...
21 0 /
Dinesh Asanka
Follow /30 Nov 2015 at 1:53pm / SQL Server

Eight Types of Slowly Changing Dimensions (SCDs)

We typically talks about three SCDs which are Type 1, Type 2 and Type 3. In Ralph Kimball and Margy Ross Third edition of the Data Warehouse Toolkit book, they talked about eight types of SCDs. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
18 0 /
Mark Broadbent
Follow /30 Nov 2015 at 1:46pm / SQL Server

Bitesize SSIS: Passing SSIS variables into script components

I hate SSIS. It seems to me that it is full of certain nuances and unless you are regularly developing SSIS packages, they are easy to forget or it is easy to miss specific important steps. I first started using SSIS back in 2005 when it was directly...
18 0 /
John Weathington

Three Smart Strategies For Avoiding Communication Problems

Communication Breakdown Communication breakdowns are the worst kinds of problems for business analysts. As a business analysts, your job centers on effective communication. However, how many times is communication (or lack thereof) blamed for broken...
9 0 /
Sten Vesterli
Follow /30 Nov 2015 at 9:47am / Oracle

Running a distributed ADF application

You might have noticed a feature called Remote Taskflows in JDeveloper 12.2.1. This feature is actually quite interesting: It allows you to use a task flow running on a completely separate server. Technically, this is like the Web Services for Report...
88 0 /
Ajith Narayanan
Follow /30 Nov 2015 at 7:19am / Oracle

Oracle Workflow Performance Issue

In this blogpost, we can see how to overcome the performance issues in our EBS environments, All our EBS workflows undergoes many test and incomplete workflow cycles, that starts giving performance issues over a time period. This is a step-by-step guide...
29 0 /
Iggy Fernandez
Follow /30 Nov 2015 at 5:16am / Oracle

OT: The Best Job Interview of My Life

I’ve written often enough about terrible job interviews ( The Worst Interview of My Life ; How Not to Interview a Database Administrator: The Google Way ; How to interview an Oracle DBA candidate NOT ) but that’s not to say that I haven’t...
338 0 /
Nakul Vachhrajani
Follow /30 Nov 2015 at 3:30am / SQL Server

#0363 – SQL Server – T-SQL Script to generate week date ranges from any given day

Recently, I was asked to help out in implementing a requirement for a reporting application. The application was designed to report weekly consumption trends from the day the report is run, and we therefore had to generate a lookup with week long date...
27 0 /
Robert Catterall
Follow /30 Nov 2015 at 1:42am / IBM DB2

DB2 for z/OS: How I Use -DISPLAY BUFFERPOOL Output

A couple of weeks ago, I was going over output of the DB2 for z/OS command -DISPLAY BUFFERPOOL with a group of people, and one of the meeting participants said words to this effect: "You've got some useful formulas and rules of thumb here. Could...
17 0 /
Mike Smithers
Follow /29 Nov 2015 at 6:00pm / Oracle

A False Sense of Security, or how Database Developers can save £35 million

Deb’s been recovering from an operation recently. During her convalescence, I have been designated as her nurse and carer. Careful planning was required prior to the op. She promised not to over do things, and I promised to attend to her every...
46 0 /
Chris Webb
Follow /27 Nov 2015 at 9:30am / SQL Server

New SSAS, Power BI And SQL Server Training Courses For 2016

I’ve just added a number of new 2016 training course dates to the Technitrain site. If you’re looking for Power BI, Analysis Services, SQL Server or Data Science training in London then please check them out! Also, if you’d like to sign up for the Technitrain...
47 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:51pm / SQL Server

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media...
57 0 /
Follow /26 Nov 2015 at 8:17pm / Oracle

BGOUG Autumn Conference - Extraordinary trip

it's 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before. since there is no direct flight to Bulgaria then...
133 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:04pm / SQL Server

Temporary Post Used For Theme Detection (b4dd5212-1214-4a73-ab89-2e9107f53b84 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (9ef4d2a7-197a-4c68-8beb-0f37348d6aec - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
69 0 /
Dan Hotka
Follow /26 Nov 2015 at 1:43pm / Oracle

Oracle11 SQL Inlining Coding Feature

Hi! I have been talking a little bit about the context switch when you are working with PL/SQL and SQL together. IF you call a function from the SQL statement, a context switch will occur to pass control to the PL/SQL engine then back when the PL...
65 0 /
Derik Hammer
Follow /26 Nov 2015 at 1:00pm / SQL Server

Statistics Parser

Today I’d like to recommend a free community tool, StatisticsParser.com . Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump...
51 0 /
Sten Vesterli
Follow /26 Nov 2015 at 12:54pm / Oracle

Brand-new Oracle Forms 12c heading out of support?

I was happy that Oracle finally got around to releasing Oracle Forms 12c, and confidently expected Oracle to offer us the normal 5 years of premier support and 3 years of extended support. But that's not what happened. You see, Oracle considers...
138 1 /
Clarisa Maman Orfali
Follow /26 Nov 2015 at 2:21am / Oracle

Definir Valores de Interfaz de Usuario por Defecto (UI) en Oracle APEX 5.0

Muchas veces estamos usando en nuestra aplicación tablas de datos en Informes/Pantallas en diferentes páginas y lo que es habitual siempre necesitamos cambiar el nombre de los encabezados de columnas para que sea más representativo...
68 0 /
Paul Turley
Follow /26 Nov 2015 at 2:09am / SQL Server

Complete DAX Function Reference

The DAX function reference documentation in MSDN can be found on separate pages,  organized by categories but you can’t view all of the functions in one page.  If you don’t know exactly what you’re looking for, this can be a bit of a hunting...
65 0 /
Ed Elliott
Follow /25 Nov 2015 at 10:42pm / SQL Server

Convert select statements in scripts into Inline-TVF's automatically

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really...
67 0 /
Fernando Garcia
Follow /25 Nov 2015 at 10:36pm / Oracle

¿Para qué sirve la cláusula CROSS APPLY?

La versión 12c del servidor de base de datos Oracle incluye una nueva extensión del lenguaje SQL: la cláusula CROSS APPLY. Existen diversos escenarios en los que dicha cláusula nos resulta de gran utilidad. En general, los...
161 0 /
Thomas LaRock
Follow /25 Nov 2015 at 5:09pm / SQL Server

The DBA Plate for 2016

Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but...
69 0 /
Ed Elliott
Follow /25 Nov 2015 at 5:07pm / SQL Server

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script. Honestly if you are doing anything with...
68 0 /