What are the different types of indexes?

684

When would you use a before or after trigger?

570

Does sql server 2000 clustering support load balancing?

657

What are the types of subscriptions in SQL Server replication?

629

How to use union to merge outputs from two queries together in ms sql server?

652

What are the difference between “where” and “having” clause in sql server?

660

What is sql stored procedure?

687

How many types of subqueries are there in sql server?

552

What is transaction server distributed transaction?

633

What is the difference between a "where" clause and a "having" clause?

714

What are the security related catalog views? : sql server security

612

How can I check that whether automatic statistic update is enabled or not?

657

What is a transact-sql statement?

615

What are parameterized reports? What are cascading parameters in ssrs reports?

110

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

650