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

IN Vs OR operator which is best to use sql server.

4 11793

Can anybody explain me cold backup and hot backup?

TCS,

3 16174

whate is advantages of sql server 2000

2159

what is the purpose of creating view is sql server 2000

Wipro,

13 22159

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 4842

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 6540

how to connect sybase to sql server 2005?.

ABC,

1 5614

how to select a field with firstletter as capital and remaining are small letters

11 19017

How to write stored procedure to update the data in 10 tables

4 13998

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 34968

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 6927

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 8773

what is difference between view and Dip.

IBM, L&T,

2409

what is curser.

9 13647

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 14570

Un-Answered Questions { SQL Server }

What are the types of resultset?

967

Why should one not prefix user stored procedures with ‘sp_’?

1046

Do you know what is lock escalation?

1011

What is the correct order of the logical query processing phases?

936

What are the disadvantages of merge replication?

1421

How do I shrink an ldf file?

980

Explain about unique identifier data type in sql server?

914

What is the purpose of self join?

974

How do you handle datasets larger than 50 gb?

162

What is the purpose of update statistics and scope_identity() function?

1100

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1887

What is 1nf normalization form?

1034

What does dml stand for?

947

How to convert a numeric expression from one data type to another?

1014

Explain primary key in sql server?

1016

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