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 2627

Is index a datbase objects in sql server?

2 2408

What is Dedicated Administrator Connection in sql server 2005?

2 3327

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

2 2192

How many types of Joins in SQL Server 2005?

HCL, CarrizalSoft Technologies,

9 6050

What is Inner Join?

2 2821

What is Outter Join?

1 1984

How many types of Outer Joins?What are they?

1 1852

What is Left Outer Join?

2 2295

What is Right Outer Join?

2 2025

What is Full Outer Join?

3 3343

What is Cross Join

3 3388

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

3 4691

What is Self Join?

4 3344

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 12923

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


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


What is Lock table in SQL?


how to overcome kernel isssues


plss anybody specify tha constrian management system in dbms


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?


If a stored procedure is taking a table data type, how it looks?


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


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


Working with TLogs


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


How retrieve field names from the table in SQL through JAVA code?


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i