Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  


How to create user messages with print statements in ms sql server?

0 Answers  


Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  


What is difference between clustered and non clustered index?

0 Answers  


how to get the automatic backup of the database in the sql server

4 Answers  


What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  


What is application role in sql server database security? : sql server security

0 Answers  


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  


What's new in sql management studio for sql server? : sql server management studio

0 Answers  


I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,


What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  


Categories