What is difference between delete & truncate commands?
What is an Index?
What is clustered vs nonclustered index?
How m-m relationships are implemented?
How to apply filtering criteria at group level with the having clause in ms sql server?
How many .ndf files can we create in Sql server 2005?
What is ddl command?
How do I find query history in sql server?
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
Explain what you mean by 3 tier architecture.
What is de-normalization and when do you do it?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
how to trace the traffic hitting a sql server? : Sql server database administration