Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked



Upload Image Close it
Select File

This blog contains various articles on the SQL Server. Also this blog contains various interview questions on the SQL Server. Through this blog I try to make the learning of SQL Server/ BI and SQL DBA very easy and in a quick time.

Browse by Tags · View All
CodeProject 6
Sql Server 4
Having Clause 3
Interview Questions on sql server 3
SQLServerPediaSyndication 3
Happy New Year 1
Rebuild And Reorganization of Indexes 1
Replication in SQL Server 1
Fragmentation in SQL Server 1
Log Shipping in SQL Server 1

Archive · View All
February 2012 20
December 2012 5
April 2012 4
August 2012 2
November 2010 2
November 2012 1
June 2012 1
May 2011 1
November 2011 1
October 2011 1

Technology With Vivek Johari

  • 1
    Liked

    Isolation levels in SQL Server

    Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the isolation level set on the...

    Vivek Johari  Posted on Aug 19 2012 11:46AM
    Profile · Blog
  • 2
    Liked

    SQL Server Functions- An Introduction

    SQL FUNCTION: - Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in the form of a single va...

    Vivek Johari  Posted on Jan 29 2012 4:52AM
    Profile · Blog
  • 2
    Liked
    2
    Comments

    SQL Triggers - An Introduction

    Introduction Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are bound to specifi...

    Vivek Johari  Posted on Jan 29 2012 4:51AM
    Profile · Blog
  • 1
    Liked

    Cursor in sql server

    Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic which means single row at a time. Cursor is the database object which solves this problem. With the use of cursor, we can fetch a...

    Vivek Johari  Posted on Nov 15 2011 9:59AM
    Profile · Blog
  • 1
    Liked

    Sql Server View

    Views:- View can be described as virtual table which derived its data from one or more than one table columns.It is stored in the database. It is used to implements the security mechanism in the Sql Server. For example, suppose there is table called Emplo...

    Vivek Johari  Posted on Nov 15 2010 4:25PM
    Profile · Blog
  • 1
    Liked

    How to find duplicate values in a table

    Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a unique key on a table. In these cases we need to find out the duplicate records and need to delete them. We can use the Having Clause to find out that du...

    Vivek Johari  Posted on Nov 15 2010 4:24PM
    Profile · Blog
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]