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 get current date in SQL server 2000

Cap Gemini, Polaris,

4 6838

How get current date in SQL server 2000

Cap Gemini,

6 9418

In the primary key have a multiple field or not?

TCS,

8 9224

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

PMAM IT Services, TCS,

7 9842

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2027

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2009

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 6084

what are the critical issues you have resloved in your company

Wipro,

1962

how can you move the master database

IBM,

1 4707

What is RMS migrations?

Satyam,

2133

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 11157

What is split brain scenario in DB mirroring?

1 11363

how do we insert 100 records at a time in a table without using for loop in database

1 4880

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 7882

in how many ways we can use count()

2 3739

Un-Answered Questions { SQL Server }

What is the contrast amongst drop and truncate?

1034

What is query optimization process?

1011

explain different types of joins? : Sql server database administration

985

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

What are the different types of sub-queries?

1043

How to connect sql server management studio express to sql server 2005 express?

1042

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

984

what happens on checkpoint? : Sql server database administration

1101

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

980

How do you check sql server is up and running?

1001

What is temporary stored procedure?

948

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

How to drop existing indexes in ms sql server?

1072

whats the maximum size of view state??

2192

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

900

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