Difference between report and query parameter. Why do we need different type of parameter?
Can we use where clause with group by?
Write the syntax for stuff function in an sql server?
Can we create clustered index on composite key?
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
What is difference between restoration and recovery in SQLServer?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Describe how to use linked server?
What are the different types of replication? How are they used?
What is use of except clause? How it differs from not in clause?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How many types of triggers are there?