Skip to content
Latest:
  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

Script(s)

technology as-is

  • Home
  • About
  • Archives by Month/Year
  • Contact Me

SQLServer

Database Hive MYSQL SQL Server 

Multiplying two positive numbers resulting in a negative number

June 23, 2018June 25, 2018 gchandra 0 Comments arithmetic overflow, bigint, hive, MySQL, SQLServer

Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its

Read more
Error Messages featured Sqoop 

SQOOP : mapred.FileAlreadyExistsException : Output directory

December 3, 2017December 3, 2017 gchandra 0 Comments Hadoop, hive, Import, SQLServer, sqoop

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 more
featured SQL Server Tips and Tricks 

SQLServer Delete Duplicate Rows

August 12, 2013December 3, 2017 gchandra 0 Comments CTE, Delete, Duplicate Rows, featured, SQLServer

Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order

Read more
SQL Server SSIS 

SSIS import mixed datatypes from Excel to SQLServer

October 7, 2010December 3, 2017 gchandra 0 Comments Mixed DataType, NULL, SQLServer, SSIS

While importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either

Read more
Database SQL Server 

Avoid Using SQL Server Cursors

May 6, 2010June 25, 2018 gchandra 0 Comments Cursors, Loop, Speedup, SQLServer, SQLServer2005, SSMS

SQL Server Cursor is a necessary evil. Its useful but at the same time its slow and time consuming when

Read more
Database SQL Server 

How to Save Column Names with Results : SQL Server 2005

June 11, 2008December 3, 2017 gchandra 7 Comments Database, Microsoft, sql server 2005, SQLServer

Whether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need

Read more
Web Coding 

Useful Undocumented SQL Server Extended Stored Procedures

September 28, 2006August 21, 2010 gchandra 0 Comments SQLServer, Stored Proc

– by Alexander Chigrik An extended stored procedure (xp) is a dynamic link library that runs directly in the address

Read more
Database 

Retrieving the First N Records from a SQL Query

May 16, 2006August 21, 2010 gchandra 0 Comments SQLServer

3 Techniques 1. Simple Fixed ‘N’ SELECT TOP 10 NewsURL, ArticleTitle, ArticleAuthor FROM NewsStoriesTable ORDER BY PublicationDate DESC 2. Dynamic

Read more
Web Coding 

ASP : Vbscript – Sqlserver Connection String

June 16, 2004August 21, 2010 gchandra 0 Comments Connection String, SQLServer, VBScript

Set Conn = Server.createobject(“ADODB.Connection”) Conn.Open “Provider=sqloledb;” & _ “Data Source=ServerName;” & _ “Initial Catalog=DatabaseName;” & _ “User Id=UserID;” & _

Read more

Subscribe to new Script(s)

Enter your email address to subscribe to this site and receive notifications of new posts by email.

Bragging

  • Classes I teach
  • Professional Connections
  • Rate My Professor
  • Rowan – TAP
  • Volunteer Spotlight – TechGirlz

Links

  • Oviam Hosting

Recent Scripts

  • Machine Learning made simple for beginners
  • JSON related articles
  • Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS
  • How to compress (bzip / gzip) a very large text quickly ?
  • Simple tutorial to install & use GNU Parallel

RSS Script(s)

  • Machine Learning made simple for beginners

Script Categories

  • Database (35)
    • Access (1)
    • MYSQL (7)
    • neo4j (1)
    • SQL Server (14)
      • Active Directory (1)
    • SQLite (2)
    • SSIS (3)
  • Error Messages (6)
  • Exception (2)
  • featured (7)
  • Hadoop (12)
    • Hive (7)
    • Spark (2)
    • Sqoop (2)
  • Interview Qn (1)
  • Machine Learning (1)
  • Misc (4)
    • Audio Conversion (2)
    • Audio Ripping (2)
    • Mp3 (2)
  • OS (26)
    • Docker (3)
    • Linux (11)
    • Mac (1)
    • Windows (12)
      • Vista (3)
      • Windows 7 (1)
  • Scripting (13)
    • Enterprise Library (1)
    • JSON (1)
    • LDAP (1)
    • Ports (1)
    • Python (4)
    • R (1)
    • skmmenu (4)
    • SMTP (1)
  • Software Development (1)
  • Softwares (31)
    • Freebies (4)
    • Open Source (4)
    • Outlook (1)
    • Team Foundation Server (2)
    • Third Party Tools (6)
      • Atalasoft DotImage 4.0 (2)
      • controls (4)
    • Tools (10)
    • Visual Studio (10)
  • Tips and Tricks (36)
  • Tutorial (1)
  • Web (74)
    • AJAX (2)
    • Asp.Net (29)
    • Browser (2)
    • Browsers (4)
    • IIS (2)
    • Javascript (2)
    • Web Coding (42)
    • WebService (1)
    • Wordpress (6)

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?

Tech GirlZ (SQL)

Tech Girlz

Tech Women (BigData)

Feedburner Stats

Recent Comments

  • Daniel on skmMenu 2.3 : Consolidated Post IE8, Firefox, Chrome
  • ANON on Hive creates folders like HIVE_UNION_SUBDIR_1
  • durgaprasad on Iterate files in folder using Spark Scala
  • Julio Cesar (@jccorrea) on Spark Scala Command line Arguments
  • umit sogut on How to Preserve Fileupload value in Asp.net ?
Copyright © 2022 Script(s). All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.