SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 3809

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

1 5978

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3504




What is the use of SCOPE_IDENTITY() function?

2 3625

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5323

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 6896

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

TCS, United Healthcare, CarrizalSoft Technologies,

8 24133

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

United Healthcare,

1 3472




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

United Healthcare,

1 3596

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 17759

What is the query optimization statistics?

1177

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 3875

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 7169

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

TCS,

2 4310

explain the type of contraints

3 2515


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is the Ticketing tool used in Wipro technologies at Bangalore...???

4788


how to overcome kernel isssues

435


Comment,Datatypes are unlimited

871


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

834


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

728






OPTIMIZATION OF SP,CURSOR,TRIGGERS

1457


How do you Implement SSIS Packages in your Project?

789


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1249


whats new about truncate in sql server 2008?

1254


How do use Having,Group by,Group function in SQL?

622


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

889


What is the difference between NOROW and LOCKROW?

1202


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

768


Working with TLogs

640