What is difference between getdate and sysdatetime in sql server 2008?
When do u use clustered index and non-clustered index?
Mention the different types of triggers?
Do you know what is a linked server in sql server?
What are the differences between having and where clause.
What are the advantages of paper records?
What is logon trigger?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the maximum row of a size?
Is the primary key column of a table an index in ms sql server?
Where is my database stored on the hard disk in ms sql server?
Describe how to use the linked server?
Why truncate is ddl?