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

how would you troubleshoot blocking? : Sql server database administration

954

how many triggers you can have on a table? : Sql server database administration

928

can we have a nested transaction? : Sql server database administration

1018

how to invoke a trigger on demand? : Sql server database administration

1020

what is a correlated sub-query? : Sql server database administration

907

what is a live lock? : Sql server database administration

912

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

968

explain what is raid and what are different types of raid configurations? : Sql server database administration

970

what are the new features introduced in sql server 2000? : Sql server database administration

883

what is a join? : Sql server database administration

1155

how to control the amount of free space in your index pages? : Sql server database administration

1003

when you create a database how is it stored? : Sql server database administration

965

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

917

what is raid and what are different types of raid configurations? : Sql server database administration

990

what are database files and filegroups? : Sql server database administration

902

Un-Answered Questions { SQL Server }

Using the customer, and order table in northwind database, please write a query to produce xml?

1022

What is the function of inner join?

1022

Explain partitioned view?

1036

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

976

Why use triggers?

980

What is inner join in sql server joins?

993

What stored procedure would you use to view lock information?

920

How to set database to be read_only in ms sql server?

968

What is a performance monitor?

933

What is Cross Join and in which scenario do we use Cross Join?

988

how can u get last observation in an unknown dataset ?

2399

what types of replication are supported in sql server? : Sql server database administration

979

What do you mean by table and field in sql?

980

Can we add an identity column to decimal datatype?

963

What is in place upgrade in sql server?

1006

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