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 would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 12551

How to get max 100 values from sql server

7 13650

What are the factors you will check for the performane optimization for a database query?

CarrizalSoft Technologies, DELL, SoftSol,

7 12000

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 5221

To find second largest salary in Employee table

CSS,

17 21037

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1 2103

How can we Use Linked Server? Uses of Linked server

IBM,

1 5682

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4389

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

IBM,

2 8835

What is Trace flag?

Wipro,

1 4701

Differences between Standby Vs No recovery?

Wipro,

2 16931

what is lazy writer?

Wipro,

1 8912

Can we move Resource database from one path to another? If yes,How can we?

Wipro,

1 7328

What is the use of Port no?

Wipro,

1 4857

Can you explain some of the DTS problems?

UBS, Wipro,

1 4927

Un-Answered Questions { SQL Server }

Can you index views?

951

Is it possible to have clustered index on separate drive from original table location?

1033

What are the different types of subquery?

1224

How do I find the sql server version?

1098

Why use identity in sql server?

1185

Explain “row_number()” in sql server with an example?

1065

What is a scheduled job or what is a scheduled task?

1028

What is clustered index

1079

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1058

When should you use an instead of trigger?

1037

What is a coalesce function?

1271

What is standby servers? Explain types of standby servers.

1067

What is sql server query analyzer?

1114

List the ways in which dynamic sql can be executed?

1074

Why we use the openxml clause?

1061

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