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 7530

How to get max 100 values from sql server

7 8393

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

DELL, CarrizalSoft Technologies, SoftSol,

7 6211




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 2842

To find second largest salary in Employee table

CSS,

17 9873

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

641

How can we Use Linked Server? Uses of Linked server

IBM,

1 3701

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 2459




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

IBM,

2 6306

What is Trace flag?

Wipro,

1 2498

Differences between Standby Vs No recovery?

Wipro,

2 11431

what is lazy writer?

Wipro,

1 5905

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

Wipro,

1 4873

What is the use of Port no?

Wipro,

1 2641

Can you explain some of the DTS problems?

UBS, Wipro,

1 2901


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

755


what is difference between view and Dip.

1164


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

782


How do use Having,Group by,Group function in SQL?

648


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

641






how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

334


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

911


where the connection string store in the database

790


what are the critical issues you have resloved in your company

789


If the job running very slow what is the action you do

687


How retrieve field names from the table in SQL through JAVA code?

672


whats new about truncate in sql server 2008?

1280


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1235


how to take backup bcp out for a column in table in sql server?

820


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

914