SQL Server Interview Questions
Questions Answers Views Company eMail

Can we drop user if user mapped to any logins

1 1737

How to transfer Logins from SQL Server 2000 to 2005

2 1698

Issues related in upgrading SQL Server 2000 to 2005 / 2008

842




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

1 1692

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

Liquid Hub,

5234

find the 3rd max salary

10 5321

How to Handle the exceptions in Sqlsrver 2005??

Value Labs, Wipro,

3 4519

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

1029




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

TCS,

2 2427

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.

759

how do u find least salary in a table

4 3193

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

TCS, Thomson Reuters,

7 7237

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

2 1974

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

2 2269

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

2 2809


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

System variable and temporary variables

1036


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

990


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

1357


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

732


1 01 101 01010

811






role of sql sever 2005 in database rather than any other database

928


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

929


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

5234


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

771


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

876


how many no of arguments can be passed in procedures and functions

3597


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

1029


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

950


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1545


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2737