Sql Server Questions - Sql Server Interview Questions

Sql Server Interview Questions

Different property of subquery

Posted on February 10th , 2012 by Admin

What is Composite Indexes in SQL Server

Posted on February 10th , 2012 by Admin

What does ON DELETE CASCADE and ON UPDATE CASCADE do

Posted on February 10th , 2012 by Admin

What is pessimistic locking

Posted on February 7th , 2012 by Admin

Different ways to move data or database between server and databases

Posted on February 7th , 2012 by Admin

What is SubQuery and its advantage

Posted on January 24th , 2012 by Admin

what editions of SQLServer data base support database mirroring

Posted on January 22nd , 2012 by Admin

Three advantage of using temporary table

Posted on January 22nd , 2012 by Admin

Different types of Security Functions

Posted on January 17th , 2012 by Admin

What is NullIf function in sql

Posted on January 17th , 2012 by Admin

What is index tuning

Posted on January 17th , 2012 by Admin

Why to use SET ANSI NULLS ON in store procedure

Posted on January 11th , 2012 by Admin

Is it possible to link SQL Server with Oracle server

Posted on January 7th , 2012 by Admin

What is default recovery model for SQL Server

Posted on January 2nd , 2012 by Admin

Can we apply identity column to decimal datatype

Posted on January 2nd , 2012 by Admin

Objects thats need to delete explicitly in database

Posted on December 28th , 2011 by Admin

What do think View occupy memory space or not

Posted on December 26th , 2011 by Admin

maximum number of tables we use for joins in a single query

Posted on December 24th , 2011 by Admin

Syntax to disable trigger

Posted on December 15th , 2011 by Admin

What do you mean by SQL Server Parameter sniffing

Posted on December 15th , 2011 by Admin

what are the magic tables

Posted on December 13th , 2011 by Admin

Can we create non primary key as cluster index

Posted on December 13th , 2011 by Admin

Difference between cluster and non cluster index in sql

Posted on December 7th , 2011 by Admin

Optimization Tips in sql

Posted on December 5th , 2011 by Admin

Transaction log file contains what

Posted on December 5th , 2011 by Admin

How to do insert update and delete statement in sql

Posted on December 2nd , 2011 by Admin

Why Group BY and Order By clause are so expensive

Posted on November 28th , 2011 by Admin

Different objects of sql server

Posted on November 28th , 2011 by Admin

What is the default value of int datatype

Posted on November 28th , 2011 by Admin

Is it possible to create foreign key without primary key

Posted on November 22nd , 2011 by Admin

What is MDF NDF and LDF in sql server

Posted on November 22nd , 2011 by Admin

SQL keywords that are used to change or set permissions

Posted on November 19th , 2011 by Admin

Merge statement in sql server 2008

Posted on November 17th , 2011 by Admin

What is Trace frag in SQL

Posted on November 9th , 2011 by Admin

Different properties and Types of SubQuery

Posted on November 9th , 2011 by Admin

What are the default system table included in every database

Posted on October 3rd , 2011 by Admin

What is synonym in sql

Posted on September 22nd , 2011 by Admin

Features of SQL SERVER 2008 R2

Posted on September 18th , 2011 by Admin

What is Identity

Posted on September 6th , 2011 by Admin

Sequence of SQL statement are processed

Posted on September 6th , 2011 by Admin

objects in SQL Server

Posted on July 29th , 2011 by Admin

What is Table Sample in SQLServer2008

Posted on June 27th , 2011 by Admin

What is Pivot and Unpivot

Posted on June 25th , 2011 by Admin

Can we call a Trigger in store procedure

Posted on June 8th , 2011 by Admin

What is a Linked Server

Posted on June 7th , 2011 by Admin

What is Service Broker

Posted on December 29th , 2010 by Admin

Table which doesnot have cluster or noncluster index is called

Posted on December 29th , 2010 by Admin

What is SQL Profiler

Posted on December 29th , 2010 by Admin

What is one to one and one to many and many to many relationship

Posted on December 22nd , 2010 by Admin

Different type of Collation Sensitivity

Posted on December 22nd , 2010 by Admin

Why not to use prefix sp in store procedure

Posted on July 15th , 2010 by Admin

What is the advantage of SET NOCOUNT ON

Posted on July 15th , 2010 by Admin

what is Sphinx,Shiloh,Yukon,Katmai,Denali

Posted on July 8th , 2010 by Admin

Where to use UPDATE STATISTICS in SQL

Posted on July 7th , 2010 by Admin

What do you mean by Identity

Posted on July 7th , 2010 by Admin

Difference Between GETDATE and SYSDATETIME

Posted on July 1st , 2010 by Admin

Why to use SQL Sequence and its drawbacks

Posted on June 3rd , 2010 by Admin

What do you mean by SQL Posting

Posted on June 3rd , 2010 by Admin

What is Filtered Index in SQL

Posted on May 26th , 2010 by Admin

When and where to use STUFF function in SQL Server and how it is different from replace

Posted on May 26th , 2010 by Admin

Why and when to Use UPDATE STATISTICS command

Posted on May 26th , 2010 by Admin

What is Linked Server in SQL Server

Posted on May 26th , 2010 by Admin

Different ways of moving data from databases

Posted on March 4th , 2010 by Admin

What is LOCK escalation

Posted on March 4th , 2010 by Admin

How and when to use LIKE statement

Posted on March 4th , 2010 by Admin

What are the different index configurations a table can have

Posted on February 23rd , 2010 by Admin

Define some facts about Temporary table and there types

Posted on February 22nd , 2010 by Admin

find out how much space is used in my transaction log

Posted on February 19th , 2010 by Admin

Get top two records without Top keyword

Posted on January 28th , 2010 by Admin

What do you mean by KEYSET Cursor

Posted on January 12th , 2010 by Admin

Here are some instruction when creating a store procedure to increase speed

Posted on January 9th , 2010 by Admin

Size of Clustered NonClustered in 2005 and 2008

Posted on January 8th , 2010 by Admin

Difference between Set and Select

Posted on December 15th , 2009 by Admin

What is Network Packet Size in SQL

Posted on December 14th , 2009 by Admin

How many different locks in SQL SERVER

Posted on December 2nd , 2009 by Admin

What is the use of OLAP

Posted on December 2nd , 2009 by Admin

What do you mean by Filtered indexes

Posted on November 18th , 2009 by Admin

Provide all the built in string function of SQL SERVER

Posted on November 16th , 2009 by Admin

what is difference between candidate key and primary key

Posted on September 9th , 2009 by Admin

How to get number of Maximum connection can be establish to SQL

Posted on August 25th , 2009 by Admin

What are Sparse Columns in Sql Server2008

Posted on July 16th , 2009 by Admin

Different index configurations table in SQL

Posted on July 16th , 2009 by Admin

How many objects SQL Server contains

Posted on July 16th , 2009 by Admin

How to get detail of error of sql from command prompt by error number

Posted on July 7th , 2009 by Admin

Why we avoid permitting null values

Posted on June 23rd , 2009 by Admin

Diffrence between Extents and Page

Posted on June 23rd , 2009 by Admin

Diffrence between varchar and nvarchar

Posted on June 23rd , 2009 by Admin

Change Tracking in SQL Server 2008

Posted on June 22nd , 2009 by Admin

Why we use SET ROWCOUNT in Sql

Posted on June 18th , 2009 by Admin

Why we use Unicode In Sql server

Posted on May 30th , 2009 by Admin

What is a join and List different types of joins

Posted on May 30th , 2009 by Admin

Difference between Triggers and Storedprocedures

Posted on May 30th , 2009 by Admin

How does .NET and SQL SERVER thread is work

Posted on May 30th , 2009 by Admin

Diffrence between temp table and table variable

Posted on May 30th , 2009 by Admin

How many types of local table in sql define with syntax

Posted on May 30th , 2009 by Admin

What is Store Procedure

Posted on May 30th , 2009 by Admin

How to get all the parameter of store procedure through query

Posted on May 30th , 2009 by Admin

What is SQL tuning

Posted on May 30th , 2009 by Admin

What is SQL injection

Posted on May 30th , 2009 by Admin

What is SET operator in SQL SERVER

Posted on May 29th , 2009 by Admin

How ROW_NUMBER function helps and what is its functioning

Posted on May 29th , 2009 by Admin

Can you define ROLLUP in SQL SERVER 2005

Posted on May 29th , 2009 by Admin

What about the SQL SERVER 2008

Posted on May 28th , 2009 by Admin