SQL Server Interview Questions
Questions Answers Views Company eMail

How get current date in SQL server 2000

Polaris, Cap Gemini,

4 2493

How get current date in SQL server 2000

Cap Gemini,

6 3912

In the primary key have a multiple field or not?

TCS,

8 4396




Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

TCS, PMAM IT Services,

7 5221

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

825

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

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 3264

what are the critical issues you have resloved in your company

Wipro,

789




how can you move the master database

IBM,

1 2912

What is RMS migrations?

Satyam,

922

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 5026

What is split brain scenario in DB mirroring?

1 7176

how do we insert 100 records at a time in a table without using for loop in database

1 3066

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 3470

in how many ways we can use count()

2 1163


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

648


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

589


How can we call UDF(User Define Function) using C# code in ASP.net ?

4627


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

563


ow to bring suspect mode datbase online from scratch

662






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

1016


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

831


How much memory that we are using in Logshipping Concept?

674


how to do partition in sqlserver

1279


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

870


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.

2649


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.

683


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 to use DTS package in 2000,2005,2008 in sql server

756


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1072