Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What are the new scripting capabilities of ssms? : sql server management studio
How to create user messages with print statements in ms sql server?
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)
What is difference between clustered and non clustered index?
how to get the automatic backup of the database in the sql server
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is application role in sql server database security? : sql server security
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What's new in sql management studio for sql server? : sql server management studio
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
What is a benefit of using an after insert trigger over using a before insert trigger?