SQL Server Interview Questions
Questions Answers Views Company eMail

Explain logical operators in sql server?

661

What methods do you follow to protect from sql injection attack?

611

List some major differences between triggers and stored procedures?

592

What is a cursor, index in sql?

668

Explain trigger and its types?

702

What are the types of stored procedures in an sql server?

556

What are the two modes of authentication in sql server?

605

What is mssql?

650

What are the advantages of using a stored procedure?

633

What are the differences between stored procedure and view in sql server?

714

What is filter index?

610

What are types of subqueries?

637

What do you mean by collation recursive stored procedure?

690

When would you use the stored procedures or functions?

676

How will you optimize a stored procedure optimization?

601


Un-Answered Questions { SQL Server }

how to invoke a trigger on demand? : Sql server database administration

640


What is an index. What are the types?

656


What are exact numeric data types in ms sql server?

593


How many triggers you can have on a table?

611


How to bind a view to the schema of the underlying tables?

663






whats the maximum size of view state??

1814


Does a server store data?

575


How can a database be repaired?

650


What is change data capture (cdc) in sql server 2008?

661


How many types of dimensions are there and what are they? : sql server analysis services, ssas

658


What is the use of sign function?

639


Do you know what is blocking?

635


Explain what is sql server english query?

613


What is the recovery model? List the types of recovery model available in sql server?

558


What is the use of tempdb? What values does it hold?

646