SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 3975

What is sorting and what is the difference between sorting and clustered indexes?

1 6169

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3654




What is the use of SCOPE_IDENTITY() function?

2 3786

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5574

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 7211

How many types of TRIGGERS are there in MS SQL Server?

TCS, United Healthcare, CarrizalSoft Technologies,

8 24720

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 3630




Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 3755

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 18457

What is the query optimization statistics?

1 1297

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 4019

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 7559

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 4509

explain the type of contraints

3 2674


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1194


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

935


If we delete pack Spec what will be the status of pack Body ?

208


what is package and it uses and how can u call a package

932


optimization techinques

1387






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

4825


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

710


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

350


role of sql sever 2005 in database rather than any other database

907


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

859


How to trouble shoot if unable to connect SQL Server

810


which backup strategy you are following at ur company

1027


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

1315


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?

656


1 01 101 01010

788