Working with EditPlus Text Editor-Regular Expression How To
Editplus is a lot better than the regular text editor, Notepad. From all it’s features I like RegExp Support the most, and than comes the block select feature. Here are…
batch script to add remove prefix zero pad bulk file rename
This post has two batch scripts: 1. Batch script to rename files with zero padded number series-prefix 2. Batch script to remove prefix of perticular length 1. Batch script to…
SQL syntax with /*! c-style comments in MySQLdump
In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in…
Top Secret of 2010-Got Revealed-Watch video free
Yes the video will reveal the top most secret of 2010!! The video will give you the Hero… How can you, I, our friends really trust our selves that what…
Ideas for select all columns but one mysql stored procedure
Assume we’ve a table with 100 rows and we need to select all columns but one.The problem is headache of actually typing out all 99 required columns!! In this blog…
No More Spool Space Teradata Query Solution
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The error: “NO MORE SPOOL SPACE”. Correct, the problem…
12 responses to “No More Spool Space Teradata Query Solution”
Kedar, this was written 10 years back and it is helpful even today. Hats off to you.
At which point is giving Spool space issue..
for Example any join condition and distinct, if there are multiple joins on which join it is causing issue.
to find this how can we find? Please help