Often it is important to know how many inserts occur per hour in a transaction table OR how many payments are made per hour OR
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.
SQL Server – INSERT Statements
INSERT can be used in different ways. The following examples will guide you the method of row constructions using INSERT. CREATE TABLE Test1( Column1 INT,
SQL Server – Foreign Key Relationships
To establish a connection between two or more tables, foreign key constraint will be used. One table’s primary key column can be referred to another
SQL Server – GETDATE(), CURRENT_TIMESTAMP in DEFAULT statements
Most of the transactional tables generally do require to have a column with DEFAULT value as current date time to identify when the transaction had
SQL Server – CASE Function- Examples
This article talks about an equivalent of Oracle SQL’s DECODE function in SQL Server. There is no such function in SQL Server but through CASE
SQL Server – Working with Duplicate Records
The following examples deals with how to retrieve or find duplicate records and how to remove them in various scenarios. Someone has asked me that
Big Data & SQL 