SQL Server Interview Questions
Questions Answers Views Company eMail

Can we do dml on views?

530

Can you index views?

482

Does view occupy space?

491

What is difference between materialized view and view?

465

How do you create a clustered index?

501

How do you drop an index?

481

How does clustered and non clustered index work?

495

What are the types of indexing?

570

What is an index in a database?

518

What is the need for indexing?

484

What are the lambda triggers?

464

Can you leave a union at any time?

505

Does union all remove duplicates?

593

What does it mean to be in union?

498

Why union all is faster than union?

481


Un-Answered Questions { SQL Server }

How do I delete a sql server database?

518


What is the difference between DATETIME2 and DATETIME?

599


Which are the two editions in which SQL Azure database available?

97


How to convert a numeric expression from one data type to another?

474


How to list all columns in a table using odbc_columns()?

516






When would you use it?

557


what is raid? : Sql server database administration

532


what exactly sql injuction.how to overcome.....

2018


What is cursors?

619


What are out-of-range errors with date and time literals?

522


How can you list all the table constraints in a database?

493


How to delete duplicate rows?

523


How to use user defined functions in expressions?

537


Is null vs coalesce?

476


How to get a list of all tables with "sys.tables" view in ms sql server?

527