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 7728

How to get max 100 values from sql server

7 8604

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

DELL, CarrizalSoft Technologies, SoftSol,

7 6510




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 2989

To find second largest salary in Employee table

CSS,

17 10211

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

727

How can we Use Linked Server? Uses of Linked server

IBM,

1 3814

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 2586




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

IBM,

2 6451

What is Trace flag?

Wipro,

1 2651

Differences between Standby Vs No recovery?

Wipro,

2 11878

what is lazy writer?

Wipro,

1 6356

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

Wipro,

1 5061

What is the use of Port no?

Wipro,

1 2773

Can you explain some of the DTS problems?

UBS, Wipro,

1 3011


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

727


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

409


Why do you want to join software field as you have done your BE in Electronics?

1072


which backup strategy you are following at ur company

1042


last function used in MS Access to convert sql what function will use in sql

910






code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1100


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1336


What is RMS migrations?

1008


wat wil hapn if we give the both read and deny read permission to user?

999


optimization techinques

1414


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

925


How to trouble shoot if unable to connect SQL Server

828


ow to bring suspect mode datbase online from scratch

741


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

754


what are the critical issues you have resloved in your company

886