SQL Server Interview Questions
Questions Answers Views Company eMail

Can we drop user if user mapped to any logins

1 1584

How to transfer Logins from SQL Server 2000 to 2005

2 1514

Issues related in upgrading SQL Server 2000 to 2005 / 2008


Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 1502

what is the Ticketing tool used in Wipro technologies at Bangalore...???

Liquid Hub,


find the 3rd max salary

10 4872

How to Handle the exceptions in Sqlsrver 2005??

Wipro, Value Labs,

3 4212

What is best institute to Learn DotNET And SQL in chennai?


Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).


2 2192

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.


how do u find least salary in a table

4 2940

Delete duplicate records from the table?(Table must have unique id)

TCS, Thomson Reuters,

7 6802

Why we are using the sql language?. What is the purpose of using this?

2 1772

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 1996

How do you connect 100 files as a flat file sources in one package of SSIS?

2 2582

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


your distribution database is full what will u do


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.


application server is slow what may be the problem


How to trouble shoot if unable to connect SQL Server


How to restore performance issues and how to check?


what is the sql equivaent of the dataset relation object ?


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


What is the query optimization statistics?


whats new about truncate in sql server 2008?


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail


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


What is data modeling and Reterminal integrity?


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?


1 01 101 01010