SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Explain few of the new features of sql server 2008 management studio

908

What are “lost updates”?

989

What command do we use to rename a db, a table and a column?

924

What is the difference between a function and a trigger?

1077

What is t-sql script to take database offline – take database online.

1079

What is a filestream?

988

What is difference between commit and rollback when used in transactions?

956

Data table as parameter in sql server?

1041

What is the xml datatype?

1053

What is the difference between index seek vs. Index scan?

1021

What is set nocount on and what is set nocount off?

932

Explain intellisense for query editing

1026

Explain primary key and foreign key constraints?

1027

Explain following error properties?

1010

Explain system scalar functions?

996

Un-Answered Questions { SQL Server }

What is schemabinding a view?

916

Is it possible to have clustered index on separate drive from original table location?

959

What the different topologies in which replication can be configured?

1083

How to trouble shoot if unable to connect SQL Server

1987

Explain how dts is used to extract, transform and consolidate data?

988

What is logshipping and its purpose?

989

What are various aggregate functions that are available?

976

What are the different authentication modes in sql server? How can it be changed?

1081

What is difference between cte and view?

908

What is the maximum row of a size?

1012

How to call a function from a stored procedure in SQL Server ?

1024

What to check if a User database is locked?

1061

how you can get the list of largest tables in a database? : Sql server administration

1045

Define inner join in sql server joins?

1053

Is it possible for a stored procedure to call itself or recursive stored procedure?

946

For More Un-Answered { SQL Server } Questions Click Here