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 12473

How to get max 100 values from sql server

7 13593

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

CarrizalSoft Technologies, DELL, SoftSol,

7 11933

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 5198

To find second largest salary in Employee table

CSS,

17 20854

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

2085

How can we Use Linked Server? Uses of Linked server

IBM,

1 5662

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4368

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

IBM,

2 8812

What is Trace flag?

Wipro,

1 4679

Differences between Standby Vs No recovery?

Wipro,

2 16874

what is lazy writer?

Wipro,

1 8895

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

Wipro,

1 7289

What is the use of Port no?

Wipro,

1 4828

Can you explain some of the DTS problems?

UBS, Wipro,

1 4894

Un-Answered Questions { SQL Server }

What is analysis service repository?

1068

Difference between uniqe index and uniqe constraint?

1045

What is the importance of a recovery model?

1094

Explain sql server authentication modes?

1188

How to delete all rows with truncate table statement in ms sql server?

1047

What is the difference between for trigger and after trigger?

1161

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1247

What are 3 ways to get a count of the number of records in a table?

1122

Explain the difference between HTTP and HTTPS in database?

1095

how can you check the level of fragmentation on a table? : Sql server administration

1040

How data can be copied from one table to another table?

1004

Explain the relational database management system (rdbms)?

1162

What is difference between inner join and join?

1096

What is resultset concur_updatable?

1054

Explain stored procedure?

1109

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