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 17250

explain different types of jions with examples briefly?

Zensar,

1 6559

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 9021

explain different types of jions with examples briefly?

Zensar,

3 10605

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

3 12031

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

HP,

17 50445

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

3 5832

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 8269

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 74416

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 7581

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

1 4638

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 101473

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 77628

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

6 9918

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

8 9699

Un-Answered Questions { SQL Server }

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2834

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1946

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

1088

Is resultset an interface?

1042

How do you Implement SSIS Packages in your Project?

1993

What stored by the model?

1143

Explain Geometry datatype in sql server 2008 with example

1049

what are the new features in SSRS?

147

If we delete pack Spec what will be the status of pack Body ?

1526

What is the difference between NOROW and LOCKROW?

2909

Explain use of expression builder.

1071

How to create a scrollable cursor with the scroll option?

1052

Do you know what is a with(nolock)?

1112

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1064

What is the maximum size of a dimension? : sql server analysis services, ssas

1102

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