SQL Server Interview Questions
Questions Answers Views Company eMail

What does top operator do?

546

What is self contained scalar sub query?

511

How can I get data from a database on another server?

491

Find nth lowest salary or get nth lowest salary?

568

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

554

What is instead of dml trigger?

564

Explain different types of self contained sub query?

518

What is the difference between grant and with grant while giving permissions to the user?

495

Explain relational data?

521

What are the different normalization forms?

589

Explain primary key, foreign key and unique key?

523

What is clr ddl trigger?

530

How to stop log file growing too big?

557

How to enable/disable indexes?

563

Difference between Inner vs outer joins?

512


Un-Answered Questions { SQL Server }

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

1580


What is sql injection? How to protect against sql injection attack?

532


What types of replication are supported in sql server?

539


What is filter index?

494


What are the different SQL Server Versions you have worked on?

523






Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106


is there a column to which a default can't be bound? : Sql server database administration

514


how many triggers you can have on a table? : Sql server database administration

470


Explain the use of keyword with encryption. Create a store procedure with encryption?

518


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

569


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1613


How sql server executes a statement with nested subqueries?

488


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2153


What is parameterized reports in ssrs ?

105


Do you know how to store and query spatial data?

576