Explain what are the basic functions for master, msdb, model, tempdb databases?
Can we write ddl in trigger?
What is difference between order by and group by?
How many tables can be joined in SQL Server?
Explain trigger and its types?
Will count(column) include columns with null values in its count?
Explain what are the authentication modes in sql server?
Explain what is public role in sql server?
Explain about merge replications?
How to create function with parameter in sql server?
What are the advantages of having an index on the sql server?
What are exact numeric data types in ms sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What structure can you implement for the database to speed up table reads?
What can be used instead of trigger?