How do you create a clustered index?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Explain what is dbcc?
Questions regarding Raiseerror?
wat is tuff file in log shipping, wt is d use of tht file?
can you any body tell me the difference between candidate key and primary key
Can you leave a union at any time?
Define primary key?
What is scalar user-defined function?
List some of the rules that apply to creating and using a ‘view’
Explain primary key?
What is self contained sub query?