Technical Archive
-
No More Spool Space Teradata Query Solution
Posted on March 2, 2010 | 4 CommentsMore...Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The query: SELECT DISTINCT fieldname FROM tablename; The error:... -
QA-Testing Definitions-Interview Questions: Part-III
Posted on February 26, 2010 | No CommentsMore...QA-Testing Definitions-Interview Questions: III (T – Z): Race Condition: A cause of concurrency problems. Multiple accesses to a shared resource, at least one of which is a write, with no... -
QA-Testing Definitions-Interview Questions: Part-II
Posted on February 26, 2010 | No CommentsMore...QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a... -
QA-Testing Definitions-Interview Questions: Part-I
Posted on February 26, 2010 | No CommentsMore...QA-Testing Definitions-Interview Questions: I (A – I) Acceptance Testing: Testing conducted to enable a user/customer to determine whether to accept a software product. Normally performed to validate the software meets... -
Audit-Checking login history-to know WHO DID THAT on Redhat Linux
Posted on February 16, 2010 | No CommentsMore...I’m using Redhat Linux (RHEL 5). Yesterday I saw a bit suspicious activities and data movements under my “home” (/home/username directory). I thought of investigate / audit through my Redhat linux... -
Buzz: Google buys Aardvark for Social Questioning
Posted on February 15, 2010 | No CommentsMore...Google announced acquisition of Aardvark – The new kind of social search. Through the “social search” term I thought it has to do something with what Google’s has said earlier... -
Whats New-Google Buzz in Gmail Inbox, Mobile
Posted on February 10, 2010 | No CommentsMore...This morn one more way of e-socializing introduced by google – Google Buzz. It’s a one of the trending topic on twitter… How to get Google buzz: Well it’s being... -
Stored procedure to add-remove prefix by rename table mysql
Posted on February 8, 2010 | 3 CommentsMore...Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes A friend of mine was renaming 100+ tables by using replace methods... -
Oracle query-eliminate duplicate but one using rowid
Posted on February 8, 2010 | 1 CommentMore...Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the... -
crontab not working with dynamic date filename – rhel linux
Posted on January 7, 2010 | No CommentsMore...I have done it for so many times, setting a cronjob. Today I was tring to set a simple cronjob which will output the log file with timestamp attached filename....