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 to provide default values to function parameters?

1068

How to use transact-sql statements to access the database engine?

1012

How to create new table with "create table" statements?

1017

How to connect php with different port numbers?

1019

How to fetch the next row from a cursor with a "fetch" statement?

1029

How to divide query output into multiple groups with the group by clause in ms sql server?

975

How to modify an existing stored procedure in ms sql server?

1027

How to transfer data from a cursor to variables with a "fetch" statement?

1034

How to drop existing indexes in ms sql server?

1022

How to concatenate two binary strings together?

1056

How to defragment table indexes?

934

Is the primary key column of a table an index in ms sql server?

926

How to generate create procedure script on an existing stored procedure?

948

How to write a query with a full outer join in ms sql server?

1017

How to concatenate two character strings together?

1066

Un-Answered Questions { SQL Server }

What is right outer join in sql server joins?

1131

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

866

Different types of keys in SQL?

1039

What are basics of policy management?

1057

How can you list all the columns in a database?

891

What are policy management terms?

943

What is entity data services?

1009

What are the disadvantages of merge replication?

1324

Do you know clustered and non-clustered index?

942

Distinguish between commit and rollback?

903

Do you know hot add cpu in sql server 2008?

907

How do I start sql server agent automatically?

923

Explain the dbcc pintable command when would you use it?

876

How to sort the query output with order by clauses in ms sql server?

990

Can I disable or restrict ssrs export formats (rendering formats)?

144

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