Explain “row_number()” in sql server with an example?
What are the types of subscriptions in SQL Server replication?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is store procedure?
Can a trigger be created on a view?
In what version of sql server were synonyms released?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is indexed view?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
whate is advantages of sql server 2000
How can we write or define DDL statements in Sql server and DML statements?
When would you use a before or after trigger?