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

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 17029

explain different types of jions with examples briefly?

Zensar,

1 6472

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 8903

explain different types of jions with examples briefly?

Zensar,

3 10463

can we call functions from stored procedure in SQL Server 2005 ? How?

3 11911

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 49886

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 5702

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 8068

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 73579

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 7381

How to list all tables having unique constraints in any of the columns in a database.

1 4561

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 100875

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 76549

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 9680

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 9454

Un-Answered Questions { SQL Server }

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1081

What is meant by dirty read?

996

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

943

How to integrate the ssrs reports in application?

985

How to add more data to the testing table in ms sql server?

1087

What are partitioned views and distributed partitioned views?

1022

Does sql server 2016 have ssms?

960

How to create a user to access a database in ms sql server using "create user" statements?

950

How can we call UDF(User Define Function) using C# code in ASP.net ?

6885

Do you know what is xpath?

1087

What stored by the msdb?

1000

How can I create a report based on a query? : sql server management studio

1015

Why use identity in sql server?

1102

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

907

What is rtm version in sql server?

1049

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