Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
No Answer is Posted For this Question
Be the First to Post Answer
List out the differences between the clustered index and non-clustered index in 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)
Do you know what are pages and extents? : SQL Server Architecture
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
How can I change procedure name in sql server?
Write a sql query to get zero records from a table having n number of records?
What is difference between drop truncate and delete?
What is the benefit of normalization?
What is collation sensitivity? Explain different types.
What is a transaction and why is it important?
what is the main difference between after trigger and instead trigger.
what kind of lan types do you know? : Sql server database administration