SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 4055

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

1 6226

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3725




What is the use of SCOPE_IDENTITY() function?

2 3849

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5673

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 7341

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

TCS, United Healthcare, CarrizalSoft Technologies,

8 24946

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

United Healthcare,

1 3681




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

United Healthcare,

1 3812

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 18754

What is the query optimization statistics?

1 1347

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 4088

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 7740

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

TCS,

2 4571

explain the type of contraints

3 2732


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

last function used in MS Access to convert sql what function will use in sql

929


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1018


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


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

950


whats new about truncate in sql server 2008?

1385






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


Issues related in upgrading SQL Server 2000 to 2005 / 2008

856


how can u get last observation in an unknown dataset ?

1244


Why do you want to join software field as you have done your BE in Electronics?

1094


query processing

1078


Tell about MOM Tool(Microsoft Operator Manager)?

761


what is checksum in sql server.........???

467


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


tell me the disaster recovery plan

1359


How to restore performance issues and how to check?

918