SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?


1 3733

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

1 5892

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 3445

What is the use of SCOPE_IDENTITY() function?

2 3567

Can we rollback records deleted by a truncate statement?

United Healthcare, CarrizalSoft Technologies,

3 5241

How many types of indexes are there in SQL Server?

United Healthcare, CarrizalSoft Technologies,

6 6789

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

TCS, United Healthcare, CarrizalSoft Technologies,

8 23908

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

United Healthcare,

1 3407

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

United Healthcare,

1 3541

Can we execute a stored procedure inside a trigger?

BirlaSoft, United Healthcare, CarrizalSoft Technologies,

6 17392

What is the query optimization statistics?


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 3839

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 7054

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


2 4273

explain the type of contraints

3 2459

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How we create SQL Server 2005 Reporting Services ? Give me Sample


What is best institute to Learn DotNET And SQL in chennai?


How can we call UDF(User Define Function) using C# code in ASP.net ?


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.


which backup strategy you are following at ur company


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?


Working with TLogs


Scalability, Availability, Integration with internet, etc.)?


ow to bring suspect mode datbase online from scratch


where the connection string store in the database


application server is slow what may be the problem


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


What are the dis_advantages of stored procedures, triggers, indexes?


What is Lock table in SQL?


How much memory that we are using in Logshipping Concept?