Click here to Skip to main content
12,452,344 members (52,648 online)

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.68

Database
SQL
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 134,743   Rating: 4.68/5    Votes: 31   Popularity: 7.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 61   Downloaded: 0
This article is written to describe all the different types of Sql Joins

Average blogs rating: 4.50

Posted: 20 Aug 2010   Updated: 29 Aug 2010   Views: 41,562   Rating: 3.92/5    Votes: 11   Popularity: 4.25
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.
SQL Server
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 71,443   Rating: 5.00/5    Votes: 10   Popularity: 5.00
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.
Posted: 12 Nov 2010   Updated: 12 Nov 2010   Views: 1,272,758   Rating: 4.80/5    Votes: 103   Popularity: 9.67
Licence: The Code Project Open License (CPOL)      Bookmarked: 78   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: 35,227   Rating: 4.29/5    Votes: 12   Popularity: 4.73
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: 27,074   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: 45,608   Rating: 4.54/5    Votes: 6   Popularity: 3.57
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: 6,941   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: 6,170   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


Advertise | Privacy | Mobile
Web01 | 2.8.160826.1 | Last Updated 29 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid