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 7584

How to get max 100 values from sql server

7 8442

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

DELL, CarrizalSoft Technologies, SoftSol,

7 6299




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 2887

To find second largest salary in Employee table

CSS,

17 9980

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

676

How can we Use Linked Server? Uses of Linked server

IBM,

1 3749

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 2519




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

IBM,

2 6347

What is Trace flag?

Wipro,

1 2553

Differences between Standby Vs No recovery?

Wipro,

2 11608

what is lazy writer?

Wipro,

1 6123

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

Wipro,

1 4936

What is the use of Port no?

Wipro,

1 2688

Can you explain some of the DTS problems?

UBS, Wipro,

1 2944


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what exactly sql injuction.how to overcome.....

1309


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

947


whats new about truncate in sql server 2008?

1310


how can you attach more than 20 ldf files in sql server

830


how to overcome kernel isssues

468






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

857


If a stored procedure is taking a table data type, how it looks?

4643


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1510


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

594


Comment,Datatypes are unlimited

917


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1151


How to trouble shoot if unable to connect SQL Server

766


How we create SQL Server 2005 Reporting Services ? Give me Sample

919


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

864


What are the dis_advantages of stored procedures, triggers, indexes?

968