SQL Server Interview Questions
Questions Answers Views Company eMail

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 2741

Is index a datbase objects in sql server?

2 2535

What is Dedicated Administrator Connection in sql server 2005?

2 3444




why SQL server is more used to store database rather than Access

2 2316

How many types of Joins in SQL Server 2005?

HCL, CarrizalSoft Technologies,

9 6337

What is Inner Join?

2 2957

What is Outter Join?

1 2108

How many types of Outer Joins?What are they?

1 1977




What is Left Outer Join?

2 2425

What is Right Outer Join?

2 2143

What is Full Outer Join?

3 3466

What is Cross Join

3 3591

Diff. b/w Full Outer Join And Cross Join?

3 4879

What is Self Join?

4 3500

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Mphasis, Logitech,

1 13281


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Tell about MOM Tool(Microsoft Operator Manager)?

741


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

1029


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

366


You are doing log shipping due to some reasons it is failing. How you will proceed from there

885


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

1198






how can you attach more than 20 ldf files in sql server

889


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.

1632


What is the difference between NOROW and LOCKROW?

1367


whats new about truncate in sql server 2008?

1366


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

768


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

773


how to do partition in sqlserver

1359


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


what is isolation level at dead lock?

1069


how to overcome kernel isssues

519