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 write an inner join with the where clause in ms sql server?

1091

What are the differences between user defined functions and stored procedures?

1071

What is index fragmentation in ms sql server?

1082

How to turn off warning messages during php execution?

1044

What are the differences between char and nchar in ms sql server?

1085

How to generate create function script on an existing function?

1111

What is a collation in ms sql server?

1083

What do you need to connect php to sql server?

1104

What is sql language?

1141

Can another user execute your local temporary stored procedures?

985

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1009

How to enable tcp/ip protocol on a sql server?

1161

How to list all objects in a given schema?

1057

How to delete existing triggers using "drop trigger"?

1053

How to download microsoft sql server 2005 express edition?

1047

Un-Answered Questions { SQL Server }

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

967

What is indexing a document?

1032

What is the use of floor function in sql server?

1081

How to encrypt Strored Procedure in SQL SERVER?

1167

How many non clustered indexes there can be on table ?

920

Explain what is the difference between union and union all?

1007

What are different types of table joins?

1004

can you implement data mining in SSRS?

148

What is the meaning of resultset type_scroll_insensitive?

956

What is the standby server?

952

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

1079

What is the difference between a view and a stored procedure?

1037

What is difference between index and primary key?

1100

Can you always create a cache of a report?

172

Write down the syntax and an example for create, rename and delete index?

982

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