SQL Server Data Types:

SQL Server Data Types: In SQL server, we have many data types and in this moment we no need to concentrate on all the data types. We will learn frequently used data types. What is data type? Data types is a category which will...

Read More

SQL SERVER – Part 1 - What is Data,Database and DBMS

Before we learn about what SQL server is and how SQL will work, first we would like to know what are DATA, DATABASE, and DBMS keywords Data:  information that has been translated into a form that it is more convenient to transfer or process Database: It is a systematic collection of data that is stored in computer DBMS: Database management...

Read More

Get Row Count Of All The Tables In SQL Server Database

Generally most of the times, People who are working as Database Developers or DBA’s will come across to Get Row Count of all the tables in Database to check if there are any table is having 0 records (Or) to Get TOP 5 huge Row Counts...

Read More

How to Fix ERROR: CANNOT PARALLELIZE AN UPDATE STATEMENT THAT UPDATES THE DISTRIBUTION COLUMNS Printable View

Error: [DataDirect][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: Cannot parallelize an UPDATE statement that updates the distribution columns(File cdbmutate.c;Line 709;Routine apply_motion;) Cause:  When Executing UPDATE...

Read More