How to Connect Teradata with MS Excel 2010

You can easily connect with your  Teradata with Excel 2010 or any version. For this you need some  modification in you connection  string.

This Pdf  provides instructions for setting up a connection from Excel 2007 or later to a
Teradata BIO-enabled Teradata Database.

Read the rest of this entry »

Primary Somapony Result | PSC Results for BD

Prathomik and Ebtedayee Somaponi exam / Primary Terminal Examination Routine 2012 Bangladesh has published today.      Click this Post        Read the rest of this entry »

How to select duplicate rows in Teradata

If you want to find all duplicate rows in a table then please run this sql.
Sql: Select Col1.Col2,Col3,Count(*) from Table1
group by 1,2,3 having count(*)>1
Read the rest of this entry »

TeraData Interview Question for Beginner(on Architechure)

1. Discuss  Teradata Basic Architecture :

NODE:
A node is made up of various hardware and software components.Components that make up a node are1.Parsing Engine (PE)2.BYNET3.Access Module Processor (AMP)4.Disks
Parsing Engine
The Parsing Engine (PE) is a component that interprets SQL requests, receives inputrecords, and passes data. To do that it sends the messages through the BYNET to theAMPs.
BYNET
The BYNET is the message passing layer. It determines which AMP(s)(Access ModuleProcessor) should receive a message.

Read the rest of this entry »

Optimize Web Server Performance in Windows Server 2003

You can get better performance  to stop other unnecessary service in Web Serer .

 

Disable Windows Server 2003 services that are not required for a dedicated Web server. To do this, follow these steps:

  1. Click Start, point to Programs, point to Administrative Tools, and then click Computer Management.
  2. Under Computer Management (Local), expand Services and Applications, and then click Services.

Read the rest of this entry »

Page 1 of 912345...Last »