The following query will help you in checking the total number of rows and the size of the table(s). SELECTs.Name AS SchemaName,t.Name AS TableName,p.rows AS
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Last Modified Date – Stored Procedure
Usually, several stored procedures will be provided to DBAs to deploy in the Production environment. Some of the existing stored procedures need to be replaced
Import from Excel – Named Sheet
This article is to let you know how to import Excel data into SQL Server. First of all download a set of components i.e OLE
Generate multiple CSV data files from SQL
Assume that there are thousands of rows in a table and the rows need to be split and saved in different CSV files based on
SQL Server – Parsing, Casting and Conversion
Sometimes the data stores in the table in a different format in comparison to the real data type it belongs to. The date might be
Clearing Screen – HDFS Terminal, Hive, Impala
Sometimes we may need to clear the screen or console window of commands or any output generated from the previous task. The following commands are
Big Data & SQL 