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 7622

How to get max 100 values from sql server

7 8492

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

DELL, CarrizalSoft Technologies, SoftSol,

7 6377

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 2919

To find second largest salary in Employee table


17 10039

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


How can we Use Linked Server? Uses of Linked server


1 3764

What are the Pre Requisites when you apply Srvice Packs?


1 2534

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


2 6375

What is Trace flag?


1 2590

Differences between Standby Vs No recovery?


2 11698

what is lazy writer?


1 6214

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


1 4974

What is the use of Port no?


1 2713

Can you explain some of the DTS problems?

UBS, Wipro,

1 2963

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance


How to restore performance issues and how to check?


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


Does any body please help me what question's have asked for SSRS in the interview?


1 01 101 01010


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 ?


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


What is data modeling and Reterminal integrity?


What is the difference between NOROW and LOCKROW?


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


How do you Implement SSIS Packages in your Project?


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


How to convert a table data in XML format in sql server?