Sql Server Interview Questions

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