Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 6169

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

1 7991

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6331

What is the use of SCOPE_IDENTITY() function?

2 6368

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 8889

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12468

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

CarrizalSoft Technologies, TCS, United Healthcare,

8 31325

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

United Healthcare,

1 5974

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

United Healthcare,

1 5773

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25001

What is the query optimization statistics?

1 2853

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 6596

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 15752

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

TCS,

2 7758

explain the type of contraints

3 5421


Un-Answered Questions { SQL Server }

How to delete duplicate rows from table except one?

989


What is bookmark link in ssrs?

244


How to count duplicated values in a column in ms sql server?

1092


What is filtered index?

1095


What are two difference between sql azure and azure tables?

159


Where are sql server usernames and passwords stored in the sql server?

1116


Why use “nolock” in sql server?

1058


What are various aggregate functions that are available?

979


How to recreate an existing index in ms sql server?

1056


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

979


What is difference between getdate and sysdatetime in sql server 2008?

1047


How do I view a stored procedure in sql server?

982


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4384


What is the difference between a unique key and primary key?

955


Explain the functionalities that views support?

1114