Sql Server Interview Questions

Different property of subquery

What is Composite Indexes in SQL Server

What does ON DELETE CASCADE and ON UPDATE CASCADE do

What is pessimistic locking

Different ways to move data or database between server and databases

What is SubQuery and its advantage

what editions of SQLServer data base support database mirroring

Three advantage of using temporary table

Different types of Security Functions

What is NullIf function in sql

What is index tuning

Why to use SET ANSI NULLS ON in store procedure

Is it possible to link SQL Server with Oracle server

What is default recovery model for SQL Server

Can we apply identity column to decimal datatype

Objects thats need to delete explicitly in database

What do think View occupy memory space or not

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

Syntax to disable trigger

What do you mean by SQL Server Parameter sniffing

what are the magic tables

Can we create non primary key as cluster index

Difference between cluster and non cluster index in sql

Optimization Tips in sql

Transaction log file contains what

How to do insert update and delete statement in sql

Why Group BY and Order By clause are so expensive

Different objects of sql server

What is the default value of int datatype

Is it possible to create foreign key without primary key

What is MDF NDF and LDF in sql server

SQL keywords that are used to change or set permissions

Merge statement in sql server 2008

What is Trace frag in SQL

Different properties and Types of SubQuery

What are the default system table included in every database

What is synonym in sql

Features of SQL SERVER 2008 R2

What is Identity

Sequence of SQL statement are processed

objects in SQL Server

What is Table Sample in SQLServer2008

What is Pivot and Unpivot

Can we call a Trigger in store procedure

What is a Linked Server

What is Service Broker

Table which doesnot have cluster or noncluster index is called

What is SQL Profiler

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

Different type of Collation Sensitivity

Why not to use prefix sp in store procedure

What is the advantage of SET NOCOUNT ON

what is Sphinx,Shiloh,Yukon,Katmai,Denali

Where to use UPDATE STATISTICS in SQL

What do you mean by Identity

Difference Between GETDATE and SYSDATETIME

Why to use SQL Sequence and its drawbacks

What do you mean by SQL Posting

What is Filtered Index in SQL

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

Why and when to Use UPDATE STATISTICS command

What is Linked Server in SQL Server

Different ways of moving data from databases

What is LOCK escalation

How and when to use LIKE statement

What are the different index configurations a table can have

Define some facts about Temporary table and there types

find out how much space is used in my transaction log

Get top two records without Top keyword

What do you mean by KEYSET Cursor

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

Size of Clustered NonClustered in 2005 and 2008

Difference between Set and Select

What is Network Packet Size in SQL

How many different locks in SQL SERVER

What is the use of OLAP

What do you mean by Filtered indexes

Provide all the built in string function of SQL SERVER

what is difference between candidate key and primary key

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

What are Sparse Columns in Sql Server2008

Different index configurations table in SQL

How many objects SQL Server contains

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

Why we avoid permitting null values

Diffrence between Extents and Page

Diffrence between varchar and nvarchar

Change Tracking in SQL Server 2008

Why we use SET ROWCOUNT in Sql

Why we use Unicode In Sql server

What is a join and List different types of joins

Difference between Triggers and Storedprocedures

How does .NET and SQL SERVER thread is work

Diffrence between temp table and table variable

How many types of local table in sql define with syntax

What is Store Procedure

How to get all the parameter of store procedure through query

What is SQL tuning

What is SQL injection

What is SET operator in SQL SERVER

How ROW_NUMBER function helps and what is its functioning

Can you define ROLLUP in SQL SERVER 2005

What about the SQL SERVER 2008

How many records can take clustured index in sql

What is Cascade and Restrict when we use DROP table in SQL SERVER

Some Tips when Optimizing Sql Server 2005 Query

What is SQL whats its uses and its component

What is heap table in SQL SERVER

What is SQL Cache Dependency in ASP.NET 2.0

How many types of local tables in SQL SERVER

How to load .NET code in SQL SERVER 2005

Where .NET CLR and SQL SERVER run

What are Checkpoint in SQL Server

Can You explain integration between SQL Server 2005 and Visual Studio 2005

What is the diffrence between SQL and Pl Sql

What is the difference between UNION ALL Statement and UNION

Write some disadvantage of Cursor

What is Log Shipping and its purpose

What are the null values in SQL SERVER

Write a Role of Sql Server 2005 in XML Web Services

What are the different types of Locks

Explain some SQL Server 2000 Query

What is Write ahead log in Sql Server 2000

What do u mean by Extents and types of Extends

What is different in Rules and Constraints

What is defaults in Sql Server and types of Defaults

What Is Database

what is Relational Database

What is COMMIT and ROLLBACK statement in SQL

What is diffrence between OSQL and Query Analyzer

What is Data Integrity and its categories

SQL Server runs on which TCP IP port and From where can you change the default port

What is the use of DBCC commands

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE

When do you use SQL Profiler

Can you explain the role of each service

What is Normalization

Can you explain what View is in SQL

How to get which Process is Blocked in SQL SERVER

Can you tell me the difference between DELETE and TRUNCATE commands

What are the Global Temporary Tables

What are the advantage of User Defined function over store procedure

Define basic functions for master and msdb and tempdb databases in Sql Server

What is Cursor

What is Collate in SQL SERVER2000

What is difference between OSQL and Query Analyzer