Click here to Skip to main content

Articles by Vivek Johari (Article: 1, Technical Blogs: 6, Tip/Tricks: 2)

Article: 1, Technical Blogs: 6, Tip/Tricks: 2

RSS Feed

Average article rating: 4.77

Database
SQL
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 99,268   Rating: 4.77/5    Votes: 28   Popularity: 6.87
Licence: The Code Project Open License (CPOL)      Bookmarked: 58   Downloaded: 0
This article is written to describe all the different types of Sql Joins

Average blogs rating: 4.47

Posted: 20 Aug 2010   Updated: 29 Aug 2010   Views: 23,805   Rating: 3.90/5    Votes: 9   Popularity: 3.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
                                     IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose, this column should contains the unique values and it can’t contains the NULL or empty values. We can use this column in the “Where”
SQL Server
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 30,105   Rating: 4.69/5    Votes: 8   Popularity: 4.14
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Database is made offline to move its physical files. There can be many ways to make a database offline. But there are three main methods which are used frequently to make the database offline. These methods are given below:-1)With the help of Alter database Command:-We can make the database offline
Posted: 12 Nov 2010   Updated: 12 Nov 2010   Views: 483,892   Rating: 4.85/5    Votes: 60   Popularity: 8.61
Licence: The Code Project Open License (CPOL)      Bookmarked: 53   Downloaded: 0
Stored Procedure in Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. This article will describe the Stored Procedure in Sql server and their benefits
Posted: 16 Nov 2010   Updated: 16 Nov 2010   Views: 25,974   Rating: 4.36/5    Votes: 9   Popularity: 4.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Views:- View can be described as virtual table which derived its data from one or more than one table columns. Through this article, I try to give the basic information about the Sql Server Views.
Posted: 16 Nov 2010   Updated: 16 Nov 2010   Views: 16,957   Rating: 4.43/5    Votes: 6   Popularity: 3.37
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
This article will try to show, how to find duplicate values in a table.
Posted: 17 Nov 2010   Updated: 17 Nov 2010   Views: 24,473   Rating: 4.58/5    Votes: 5   Popularity: 3.18
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Tables can be defined as the structure which contains the data in the database. Through this article, I to give the basic information about the different ways of creating a table

Average tips rating: 4.11

Programming Tips
General
Posted: 26 Nov 2010   Updated: 26 Nov 2010   Views: 2,774   Rating: 3.50/5    Votes: 3   Popularity: 0.95
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Nice tip :)But if you have any column say empid which have the unique constraint then it is better to use the following SQL queryselect count(distinct empid ) from employees
Posted: 26 Nov 2010   Updated: 26 Nov 2010   Views: 3,212   Rating: 4.71/5    Votes: 5   Popularity: 3.22
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Nice tip Kanasz :) You can also create the linkedserver through SQL SERVER MANAGEMENT STUDIO by following the following pathClick on the Server ObjectsRight click on the Linked servers under the Server Objects and select the New linked Server option.
No reference articles have been posted.

Vivek Johari
Technical Lead
India India
I am currently working as a Analyst and have around 7.5 years of experience in database.
 
Degree:-
Master Degree in Computer(MCA)
 
Work experience:-
Designing of the database.
Database Optimization.
Writing Complex Stored Procedures,Functions,Triggers etc.
Designing and developing SSIS & DTS packages.
Designing SQL Reports using SSRS.
Database Server Maintenance.
 
Certification:-
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)
 
My other publication
Technical Blog:- Technologies with Vivek Johari
 
Moderator and Blogger at BeyondRelational.com
 
Guest Author and Blogger at sqlservercentral.com
Follow on   Twitter   Google+   LinkedIn


Advertise | Privacy | Mobile
Web01 | 2.8.140718.1 | Last Updated 22 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid