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 12258

How to get max 100 values from sql server

7 13389

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

CarrizalSoft Technologies, DELL, SoftSol,

7 11674

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 5124

To find second largest salary in Employee table

CSS,

17 20381

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

2026

How can we Use Linked Server? Uses of Linked server

IBM,

1 5590

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4309

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

IBM,

2 8716

What is Trace flag?

Wipro,

1 4626

Differences between Standby Vs No recovery?

Wipro,

2 16710

what is lazy writer?

Wipro,

1 8818

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

Wipro,

1 7207

What is the use of Port no?

Wipro,

1 4745

Can you explain some of the DTS problems?

UBS, Wipro,

1 4812

Un-Answered Questions { SQL Server }

How to execute a sql statement using mssql_query()?

1051

Why variables called the most powerful component of ssis?

1079

Describe in brief authentication modes in sql server.

1027

What do you need to connect php to sql server?

1104

Explain mixed authentication mode of sql server?

1063

What are the steps you will take to improve the performance of a poor performing query?

979

Tell me extended events in sql server 2008?

996

How to enter binary string literals in ms sql server?

1160

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

Can multiple columns be used in sql group by clause in ms sql server?

1050

Why we need to use secondry database file? though, we can do same work using primary database file also.

6885

What is filter index?

951

System variable and temporary variables

2250

Explain syntax for viewing trigger?

924

Explain the third normal form(3nf)?

943

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