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 enter comments in transact-sql statements?

985

How to loop through result set objects using mssql_fetch_array()?

1130

How to use user defined functions in expressions?

1151

How to use group functions in the select clause in ms sql server?

1116

How to list all dsn entries on your local machine using odbc_data_source()?

1089

How to count rows with the count(*) function in ms sql server?

1057

What happens if the update subquery returns multiple rows in ms sql server?

1168

What happens if the update subquery returns no rows in ms sql server?

1173

How to change the name of a database user?

1008

What is the security principal at the database level that represents your session?

991

How to loop through result set objects using odbc_fetch_row()?

1043

What are triggers in ms sql server?

1224

How to disable triggers using "disable trigger"?

1104

Can the query output be sorted by multiple columns in ms sql server?

1028

How many ways to create table-valued functions?

1054

Un-Answered Questions { SQL Server }

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1251

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

158

How to select all columns of all rows from a table with a select statement in ms sql server?

1190

Why normalization is used?

1065

How to defragment indexes with alter index ... Reorganize?

1134

What encryption security is available in sql azure?

101

What do you mean by an execution plan? Why is it used? How would you view it?

981

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2851

what is the system function to get current user's user id? : Sql server database administration

1045

Why use identity in sql server?

1168

Tell me what is difference between view and materialized view?

979

What do you understand by replication in sql server? Mention the different types of replication in sql server.

991

What is an index in sql?

1066

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1047

can an automatic recovery be initiated by a user? : Sql server administration

991

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