SQL Server Interview Questions
Questions Answers Views Company eMail

How get current date in SQL server 2000

Polaris, Cap Gemini,

4 2708

How get current date in SQL server 2000

Cap Gemini,

6 4125

In the primary key have a multiple field or not?

TCS,

8 4623




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 5457

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 ?

930

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

876

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 3404

what are the critical issues you have resloved in your company

Wipro,

904




how can you move the master database

IBM,

1 3052

What is RMS migrations?

Satyam,

1036

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 5340

What is split brain scenario in DB mirroring?

1 7798

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

1 3239

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 3676

in how many ways we can use count()

2 1392


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

whats the maximum size of view state??

1023


What is the difference between NOROW and LOCKROW?

1393


tell me the disaster recovery plan

1359


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1116


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?

947






plss anybody specify tha constrian management system in dbms

886


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

1353


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

985


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

936


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

747


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

980


How to trouble shoot if unable to connect SQL Server

854


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

748


sql database suspect We have a sql database that is showing as suspect. How can we recover?

788


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.

1643