What is the cartesian product of the table?
What are the types of database recovery models?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Do you know what is replace and stuff function in sql server?
What is sql server schema compare? How we can compare two database schemas?
Explain the difference between cross join and full outer join?
Explain what is the purpose of sql profiler in sql server?
What is index in an assignment?
Explain primary key in sql server?
Do you know exporting and importing utility?
What is a data source file?
How does stuff differ from the replace function?
What is etl - extraction, transformation, and loading?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is the sql server agent?