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

CSS,

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

689

How can we Use Linked Server? Uses of Linked server

IBM,

1 3764

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 2534




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

IBM,

2 6375

What is Trace flag?

Wipro,

1 2590

Differences between Standby Vs No recovery?

Wipro,

2 11698

what is lazy writer?

Wipro,

1 6214

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

Wipro,

1 4974

What is the use of Port no?

Wipro,

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.

1601


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

887


How to restore performance issues and how to check?

861


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

859


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

897






1 01 101 01010

765


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 ?

875


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

834


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

890


What is data modeling and Reterminal integrity?

682


What is the difference between NOROW and LOCKROW?

1318


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

4791


How do you Implement SSIS Packages in your Project?

847


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

913


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

1416