Discuss in the Community - Toad World

Discuss in the Community


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...
19 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...
69 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...
15 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...
21 0 /
Denny Cherry
Follow /25 Nov 2015 at 4:00pm / SQL Server

Inline Nonclustered Indexes

One of the new features that I just recently learned about in SQL Server 2014 is the ability to create nonclustered indexes on a table inline with the creation of the table. This is handy in a couple of ways. First it makes it so that all the indexes...
32 0 /
Craig Mullins
Follow /25 Nov 2015 at 4:00pm / IBM DB2

Happy Thanksgiving 2015

Every year this week those of us in the USA take time out to give thanks for all that we have. We do this by taking time off of work, gathering with our families, eating turkey (and a lot of other stuff), and watching football. It is one of my favorite...
60 0 /
Norm [TeamT]
Follow /25 Nov 2015 at 3:45pm / Oracle

UTL_FILE Operation fails with ORA-29283

A process that called ”UTL_FILE” was failing in the test system, but worked fine with exactly the same set up in production. Why? The error was ORA-29283: invalid file operation. How do we find out exactly why it was failing? MY_DIRECTORY...
24 0 /
Kenneth Fisher
Follow /25 Nov 2015 at 2:00pm / SQL Server

Women in technology

Earlier this week a friend of mine (Lynn Swayze (Hall) ( b / t )) posted this great article on women in technology . It’s a great read and I highly recommend it. In fact, go read it right now. I’ll wait. You’re back? Good. So, her...
39 0 /
Svetoslav Gyurov
Follow /25 Nov 2015 at 10:04am / Oracle

How to rename ASM disk groups in Exadata

Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default  ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t...
34 0 /
Deiby Gomez
Follow /25 Nov 2015 at 6:40am / Oracle


In our daily tasks as a Database Administrator it's common to see requests to get the DDL sentence from any object. Everybody knows that there is the package DBMS_METADATA that can be used for this kind of requests. But most of the DBAs uses DBMS_METADATA...
112 0 /
Clarisa Maman Orfali
Follow /25 Nov 2015 at 2:20am / Oracle

Crear Informe-Formulario tipo Maestro-Detalle en Oracle APEX 5.0

Una de las más populares características en Oracle APEX es el asistente para crear un formulario del tipo Maestro/Detalle con el cual fácilmente podemos crear un informe y su correspondiente formulario (Pantalla) para manejar los...
48 0 /
Chris Webb
Follow /24 Nov 2015 at 10:42pm / SQL Server

Using Parameter Tables To Control Data Refresh In Power BI

The use of parameter tables is a well-known technique in Power Query. It involves using a table from the current Excel workbook to hold various parameter values that are read using a Power Query query, and these parameter values are then passed to another...
56 0 /
Ed Elliott
Follow /24 Nov 2015 at 8:44pm / SQL Server

Changing case of T-SQL Keywords

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person "Mr Bert Ernie" anyway I digress, whether you are working by yourself or in a team you sometimes want to...
31 0 /
Paul Turley
Follow /24 Nov 2015 at 8:21pm / SQL Server

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 mean for companies using Reporting Services, Analysis Services and other BI features? I was recently interviewed for a CIO Magazine article by freelance writer Andy Patrizio about what the end of...
48 0 /
Sten Vesterli
Follow /24 Nov 2015 at 7:56pm / Oracle

Be careful when upgrading VMware

If you are running VMware 5.0 or 5.1, you'll be aware that support runs out August 2016. However, upgrading VMware has important implications for your Oracle licensing. In 5.0 and earlier, you only had to license the cluster you were running VMware...
82 0 /
Bob Pusateri
Follow /24 Nov 2015 at 6:33pm / SQL Server

SQL Saturday Chicago 2016 Registration Open!

Registration is now open for Chicago’s 6th SQL Saturday ! It will be taking place at DeVry University’s Addison Campus on March 5 2016. Please join us! If you’re not familiar with SQL Saturday , it’s a free day of training for...
43 0 /
Jason Strate
Follow /24 Nov 2015 at 4:00pm / SQL Server

Tuesday Morning SQL Break – November 24, 2015

It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform technology and career related information...
60 0 /
Chris Yates
Follow /24 Nov 2015 at 3:00pm / SQL Server

Why Should Data Professionals Automate?

Take a minute and look around you. Automation is all around you; whether you see it or not processes are automated on all levels of life. One thing that I’ve noticed among professionals is that “change” is very difficult; while others do not know what...
45 0 /
Ed Elliott
Follow /24 Nov 2015 at 12:28pm / SQL Server

Quickly deploying procedure/functions from SSDT (Bypass Publish)

SSDT is great but one thing that is not so great is the performance of the publish. I am not complaining, I understand it does a lot and is well worth the wait when publishing however, when you are writing and testing code having this process really kills...
49 0 /
Ricardo Leka
Follow /24 Nov 2015 at 10:16am / SQL Server

SQL Saturday #469 – Brasilia

E aí pessoal !!! O conteúdo da palesta sobre backup parcial e restauração parcial e online está disponível. O Slide está disponível para download ou visualização abaixo O link para o download dos scripts e da apresentação está aqui . Quero, novamente...
48 0 /
Ed Elliott
Follow /24 Nov 2015 at 12:20am / SQL Server

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This is really cool but if you round-trip the T-SQL into an AST and back you lose some important...
59 0 /
Follow /23 Nov 2015 at 10:55pm / SQL Server

Datatypes or Data Types?

I conducted a Twitter poll last week about how to spell DATATYPE (or is it DATA TYPEs?).  Many compound words start out as two separate words, then get hyphenated, then concatenated to a new word.  We saw this with: data base –> data-base...
60 0 /
Fernando Garcia
Follow /23 Nov 2015 at 8:04pm / Oracle

Conociendo el lenguaje SQL y CROSS APPLY

Versión tras versión el servidor de base de datos Oracle nos sorprende con nuevas prestaciones. Oracle no sólo potencia su motor de base de datos a lo largo de los años, sino que también enriquece su lenguaje SQL agregando...
146 0 /
Henrik Loeser
Follow /23 Nov 2015 at 4:28pm / IBM DB2

IDUG 2015 in Dublin: A week with friends

41 0 /
John Pertell
Follow /23 Nov 2015 at 2:00pm / SQL Server

SQL 2016 and R – Working With SQL Data

In the last few posts I’ve gone over installing the components you need to run R in a SQL 2016 instance as well as some simple scripts that played with one of the data sets that’s included with R. Today we’ll start working with data stored inside a SQL...
132 0 /