What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?1 3115
Define Check points and End Points?1 2265
How to know whether our backup is succesfully taken?1 2010
What is a Lock and let me know Different types of locks?2 3219
What is a Trace frag?Where can we use this?1 2271
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?2 3182
What is Schema? and why we use schemas?4 5969
Explain Different types of Projects?1 2465
Please tell me some knowledge about Clustering and how to add clustering?1 2453
Explain about system stored procedure?
How to delete multiple rows with one delete statement in ms sql server?
What are synonyms?
Which are the third-party tools used in sql server and why would you use them?
What are the tools available in market as an alternative to sql server reporting services?
Explain the purpose of indexes?
What is a view and what are its advantages?
How would you choose between a clustered and a non-clustered index?
Where the sql logs gets stored?
Difference between DELETE and TRUNCATE?
Explain alternate key, candidate key and composite key in sql server?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Tell me what are cursors and when they are useful?
What happens if null values are involved in bitwise operations?
Tell me about joins in database system and explain each in detail.