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)?


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


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


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


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


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


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.


What is the difference between NOROW and LOCKROW?


whats new about truncate in sql server 2008?


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?)


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


how to do partition in sqlserver


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


what is isolation level at dead lock?


how to overcome kernel isssues