Profile

Cover photo
Vivek Johari
Attended Guru Gobind Singh Indraprastha University
Lives in Delhi
1,009,871 views
AboutPostsPhotosVideos+1's

Stream

Vivek Johari

Shared publicly  - 
 
Indus Valley Civilization is the world’s oldest civilization.So, India is the world’s oldest, most advanced and continuous civilization.
India has the world’s third largest active army, after China and USA but India has never invaded or attacked a country.
Today, India is the world’s third largest economy.
The Tirupati Balaji temple and the Kashi Vishwanath Temple both, receive more visitors than the Vatican City and Mecca combined.
Every 12 years, a religious gathering called the Kumbh Mela occurs in India. It is the world’s largest gathering of people.
Varanasi, also known as Benaras, was called "the Ancient City" when Lord Buddha visited it in 500 B.C., and is the oldest, continuously inhabited city in the world today.
India has third largest Muslim population in the world and has more mosques (300,000 mosques) than any other nation in the world.
Jews and Christians have lived continuously in India since 200 B.C. and 52 A.D. respectively
Two major religions, Buddhism and Jainism, were established in India.
Takshila is said to be the first every university in the world; it started around 700 BC.
Indian Railways employs more than 1.3 million people. That’s more than the population of many nations.
India is the largest democracy in the world. More than 54 crore people voted in the 2014 General Election – more people than the population of USA, UK, Australia and Japan combined.
India has the largest English speaking population in the world.
India’s space program is one of the top 5 space programs in the world and off course we invented water on the moon.
Chess was invented in India.
And discovered the number zero.
And the value of pi. 
And trigonometry, algebra, calculus.
Ayurveda is the earliest school of medicine known to mankind. The Father of Medicine, Charaka, consolidated Ayurveda 2500 years ago.
Cataract surgery and plastic surgery are invented in India
Around the 17th century, India was one of the richest countries in the world.
India is one of the only three countries that makes supercomputers (the US and Japan are the other two).
India has the largest amount of vegetarians in the world. So much so that Pizza Hut had to open their first pure vegetarian restaurant in the country and KFC had to introduce a “vegetarian” menu for India.
India gave the world Yoga, that has existed for more than 5,000 years.
Martial Arts was first created in India.
Wishing you a very Happy Independence Day " We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.      Some facts abou...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Happy Independence Day - Jai Hind
Wishing you a very Happy Independence Day " We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. " Albert Einstein .      Some fact about India  Indus Valley Civilization is the worl...
Wishing you a very Happy Independence Day " We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.      Some fact about In...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Script to find all the triggers defined on a database or on a single table
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:- SELECT        tbl.name as [Table Name]      , trig.name as [Trigger Name]      , trig.is_disabled  FROM [sys].[triggers] as trig INNER JOIN ...
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:- SELECT        tbl.name as [Table Name]      , trig.name as [Trigger Name]      , trig.is_disabled  FROM [s...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Read this article to know the answers of important interview questions given below:-

1) Can we create clustered index on a column containing duplicate values?

 2) Can we create a Primary Key on a table on which a clustered index is already defined?

3) If a clustered index is already defined on a table and we create a primary key on this table, then is there any index is automatically created on the column on which Primary key is defined? 
Through this article, we are going to discuss three important interview questions of SQL which are given below:-  1) Can we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Interview question - Is Clustured index on column with duplicate values possible?
One of the most interesting question I have face is, Can we create clustered index on a column containing duplicate values? Many people say no as they always consider clustered index and Primary key together and primary key can only be created on column wit...
One of the most interesting question I have face is, Can we create clustered index on a column containing duplicate values? Many people say no as they always consider clustered index and Primary key together and primary ke...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:- Create table emp_pl...
1
Add a comment...
In his circles
543 people

Vivek Johari

Shared publicly  - 
 
Indus Valley Civilization is the world’s oldest civilization.So, India is the world’s oldest, most advanced and continuous civilization.
India has the world’s third largest active army, after China and USA but India has never invaded or attacked a country.
Today, India is the world’s third largest economy.
The Tirupati Balaji temple and the Kashi Vishwanath Temple both, receive more visitors than the Vatican City and Mecca combined.
Every 12 years, a religious gathering called the Kumbh Mela occurs in India. It is the world’s largest gathering of people.
Varanasi, also known as Benaras, was called "the Ancient City" when Lord Buddha visited it in 500 B.C., and is the oldest, continuously inhabited city in the world today.
India has third largest Muslim population in the world and has more mosques (300,000 mosques) than any other nation in the world.
Jews and Christians have lived continuously in India since 200 B.C. and 52 A.D. respectively
Two major religions, Buddhism and Jainism, were established in India.
Takshila is said to be the first every university in the world; it started around 700 BC.
Indian Railways employs more than 1.3 million people. That’s more than the population of many nations.
India is the largest democracy in the world. More than 54 crore people voted in the 2014 General Election – more people than the population of USA, UK, Australia and Japan combined.
India has the largest English speaking population in the world.
India’s space program is one of the top 5 space programs in the world and off course we invented water on the moon.
Chess was invented in India.
And discovered the number zero.
And the value of pi. 
And trigonometry, algebra, calculus.
Ayurveda is the earliest school of medicine known to mankind. The Father of Medicine, Charaka, consolidated Ayurveda 2500 years ago.
Cataract surgery and plastic surgery are invented in India
Around the 17th century, India was one of the richest countries in the world.
India is one of the only three countries that makes supercomputers (the US and Japan are the other two).
India has the largest amount of vegetarians in the world. So much so that Pizza Hut had to open their first pure vegetarian restaurant in the country and KFC had to introduce a “vegetarian” menu for India.
India gave the world Yoga, that has existed for more than 5,000 years.
Martial Arts was first created in India.
Wishing you a very Happy Independence Day " We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made. "Albert Einstein.      Some facts abou...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:- SELECT        tbl.name as [Table Name]      , trig.name as [Trigger Name]      , trig.is_disabled  FROM [s...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Through this article, we are going to discuss three important interview questions of SQL which are given below:-  1) Can we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
One of the most interesting question I have face is, Can we create clustered index on a column containing duplicate values? Many people say no as they always consider clustered index and Primary key together and primary ke...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:- Create table emp_pl...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:- Create table emp_pl...
1
Add a comment...
People
In his circles
543 people
Work
Occupation
Analyst / SQL DBA (MCTS SQL BI, MCTS SQL DBA) & OCP
Skills
SQL Server, ORACLE, SSIS, SSRS, SSAS, ASP, .Net
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Delhi
Previously
dwarka
Story
Tagline
OCP / MCTS / ANALYST / Technical Blogger
Introduction
Currently working as a Analyst and have around 8.5 years of experience in database. Have done Masters in Computer .  Have extensive experience in database designing ,Database Optimization, SSIS, Designing complex Reports using SSRS, Database Server Maintenance. Currently, working in an Indian MNC .Have done many certifications which Includes Microsoft certified Sql DBA in Sql server 2008 (MCTS), Microsoft certified BI professional in Sql server 2008 (MCTS), Oracle certified profession DBA in ORACLE 10g (OCP),certified profession DBA in ORACLE 9i (OCP). Also Guest author at Sqlservercentral.com, BeyondRelational.com. and Toadworld.com
Education
  • Guru Gobind Singh Indraprastha University
    MCA, 2003 - 2006
  • University of Delhi
    BSc(Hons) Mathematics, 2000 - 2003
  • Oracle
    OCP (DBA) in Oracle 10g and 9i, 2009 - 2009
  • Microsoft
    MCTS (Sqlserver DBA and Sql server BI), 2011 - 2011
Basic Information
Gender
Male
Relationship
Single
Vivek Johari's +1's are the things they like, agree with, or want to recommend.
Happy Independence Day - Jai Hind
www.techmixing.com

Wishing you a very Happy Independence Day " We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific

Interview question - Is Clustured index on column with duplicate values ...
www.techmixing.com

One of the most interesting question I have face is, Can we create clustered index on a column containing duplicate values? Many people say

Different ways to create a table and insert data into the table
www.techmixing.com

Tables can be defined as the structure which contains the data in the database. There can be many ways to create table and to insert data in

Script to find complete months between two given dates
www.techmixing.com

Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as example Startdat

Script to find the complete weeks within two given dates
www.techmixing.com

Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given

Interview Questions
www.techmixing.com

Interview Questions on SQL Server -Part-1 Interview Questions On SQL Server -Part 2 Interview Questions on SQL Server -Part 3

SQL Tips
www.techmixing.com

How to remane a Table in Sql Server? How to change the database collation? How to find duplicate values in a table? How to make database off

Question of the Week
www.techmixing.com

From today onwards I have added a new section in my blog "Question of the Week". In this section, I will be going to ask SQL puzzle twice a

Articles Index
www.techmixing.com

Basic Concepts Database Creation Database Creation using Create Database command Database Creation using SQL Sever Management Studio (SSMS)

SQL Script to find the missing indexes
www.techmixing.com

Performance tuning in SQL is regular exercise and index creation is an important part of it. Below script will help in finding the missing i

SQL Server - Convert() function
www.techmixing.com

Convert () function in SQL Server to convert an expression from one data type to another data type Syntax for CONVERT function CONVERT ( dat

SQL SERVER - Data types
www.techmixing.com

In relational database, we store data in tabular form where data is divided into columns. Each column has a name and a data type which shows

SQL Script to find the list of all the jobs failed yesterday
www.techmixing.com

One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all th

SQL Script to find the databases size
www.techmixing.com

Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used to find out the size of all the databases

SQL Script to find the tables created from a given date
www.techmixing.com

Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date. SELECT [name] as Tabl

SQL Script to search stored procedures containing a given text
www.techmixing.com

Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the

T-SQL script to find the growth size of database files
www.techmixing.com

Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLAR

SQL Script to find the last executed commands on the SQl Server
www.techmixing.com

Sometimes we needs to find out the last executed commands on the database server. Below is the SQL script share by one of my friend Ken Wats