Multiplying two positive numbers resulting in a negative number
Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its
Read more
SQLServer
SQOOP : mapred.FileAlreadyExistsException : Output directory
Sometimes when you import data from RDBMS to Hadoop via Sqoop you will see this error. org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory hdfs://hadoopcluster/user/username/importtable
Read moreSQLServer Delete Duplicate Rows
Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order
Read moreSSIS import mixed datatypes from Excel to SQLServer
While importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either
Read more
Avoid Using SQL Server Cursors
SQL Server Cursor is a necessary evil. Its useful but at the same time its slow and time consuming when
Read moreHow to Save Column Names with Results : SQL Server 2005
Whether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need
Read moreUseful Undocumented SQL Server Extended Stored Procedures
– by Alexander Chigrik An extended stored procedure (xp) is a dynamic link library that runs directly in the address
Read moreRetrieving the First N Records from a SQL Query
3 Techniques 1. Simple Fixed ‘N’ SELECT TOP 10 NewsURL, ArticleTitle, ArticleAuthor FROM NewsStoriesTable ORDER BY PublicationDate DESC 2. Dynamic
Read moreASP : Vbscript – Sqlserver Connection String
Set Conn = Server.createobject(“ADODB.Connection”) Conn.Open “Provider=sqloledb;” & _ “Data Source=ServerName;” & _ “Initial Catalog=DatabaseName;” & _ “User Id=UserID;” & _
Read more