Question Bank for SQL Database Optimization Set 1

Database Optimization
======================
What are indexes?
How will you tune your queries?
How will you find slow running queries?
What are B-Trees?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
What are "Table Scan's" and "Index Scan's"?
What are the two types of indexes and explain them in detail?
What is "FillFactor" concept in indexes?
What is the best value for "FillFactor"?
What are "Index statistics"?
How can we see statistics of an index?
How do you reorganize your index, once you find the problem?
What is Fragmentation?
How can we measure Fragmentation?
How can we remove the Fragmented spaces?
What are the criteria you will look in to while selecting an index?
What is "Index Tuning Wizard"?
What is an Execution plan?
How do you see the SQL plan in textual format?
What is nested join, hash join and merge join in SQL Query plan?
What joins are good in what situations?

www.codecollege.NET

Question Bank for SQL Replication Set 1

Replication
=================
Whats the best way to update data between SQL Servers?
What are the scenarios you will need multiple databases with schema?
How will you plan your replication?
What is a publisher, distributor and subscriber in "Replication"?
What is "Push" and "Pull" subscription?
Can a publication support push and pull at one time?
What are different models / types of replication?
What is Snapshot replication?
What are the advantages and disadvantages of using Snapshot replication?
What type of data will qualify for "Snapshot replication"?
What's the actual location where the distributor runs?
Can you explain in detail how exactly "Snapshot Replication" works?
What is merge replication?
How does merge replication works?
What are advantages and disadvantages of Merge replication?
What is conflict resolution in Merge replication?
What is a transactional replication?
Can you explain in detail how transactional replication works?
What are data type concerns during replications?

www.codecollege.NET

Question Bank for SQL Reporting Services set 1

Reporting Services
=================
Can you explain how can we make a simple report in reporting services?
How do I specify stored procedures in Reporting Services?
What is the architecture for "Reporting Services "?
What are data-driven subscriptions?
How does the report manager work in SSRS?
What is Reporting Services
What are the Reporting Services components..?

www.codecollege.NET

Question Bank for Service Broker, Integration Services/DTS Set 1

Service Broker
==============
What do we need Queues?
What is "Asynchronous" communication?
What is SQL Server Service broker?
What are the essential components of SQL Server Service broker?
What is the main purpose of having Conversation Group?
How to implement Service Broker?
How do we encrypt data between Dialogs?

Integration Services/DTS
=========================
What is Integration Services import / export wizard?
What are prime components in Integration Services?
How can we develop a DTS project in Integration Services?

www.codecollege.NET

Question Bank for Notification Services set 1

Notification Services
=====================
What are notification services?
What are basic components of Notification services?
Can you explain architecture of Notification Services?
Which are the two XML files needed for notification services?
What is Nscontrols command?
What are the situations you will use "Notification" Services?

www.codecollege.NET