what is normalization? Explain different levels of normalization? : Sql server database administration
1319what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
1130what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
1034what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
923what are user defined datatypes and when you should go for them? : Sql server database administration
1018what is the difference between delete table and truncate table commands? : Sql server database administration
1033what is the information that can be stored inside a bit column? : Sql server database administration
963
Tell me what is difference between clustered and non clustered index?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What do you think of this implementation? Can this be implemented better?
In which sql server version report builder introduced?
What is the name of the Database which IBM mainframe uses?
How to create a user to access a database in ms sql server using "create user" statements?
Can we use trigger new in before insert?
List the advantages of using stored procedures?
Why can there be only one clustered index and not more than one?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is log cache in sql server?
What is the difference between system objects and user objects?
What are the components of dbms?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is the use of group by clause?