DrivetoExcel.com Blog

0

Toad application is not working properly

Yesterday you could run Toad without any problems, and today you cannot even open the program. It immediately minimizes as an icon on the desktop. This is still not working even after re-starting the...

2

SQL Server View

View is a virtual table, which contains rows and columns based on the DML query being used to fetch the result-set. In another words, we can say view is clone of a real table...

0

Partiitioned Primary Index

Partitioned Primary Index is an indexing mechanism in Teradata database that is used for distribution of rows based on different partition. The idea behind partitioning is to put similar rows together and allow database to...

0

Tables in MultiLoad

1. ET TABLE – Data error MultiLoad uses the ET table, also called the Acquisition Phase error table, to store data errors found during the acquisition phase of a MultiLoad import task. 2. UV...

0

SQL Queries

QUE1 : Find the second highest records from each department. ANS : with cte1 as ( SELECT ROW_NUMBER() OVER(PARTITION BY Dept_id ORDER BY Salary) AS RowID, * FROM emp ) SELECT * FROM cte1...

1

Basic thumb rules for performance tuning

1.     Avoid Product Join when Possible A Cartesian join is also known as cross join. It will return all records where each row from the first table is combined with each row from the...