I can’t help much if you don’t provide the details. If you want to learn it, I can suggest you few articles (on BOL).

Fill Factor

http://msdn.microsoft.com/en-us/library/ms177459.aspx

fill factor Option

http://msdn.microsoft.com/en-us/library/ms191005.aspx

Reorganizing and Rebuilding Indexes

http://msdn.microsoft.com/en-us/library/ms189858.aspx

How big is the table? What’s the use of table (transaction / master)?

SQLRNNR (12/30/2011)

---

What if we decide to visit your casino - do you still...

Interview Question? 😀

CELKO (12/30/2011)

---

Is this an exercise? It is a bad approach to SQL and RDBMS.

The purpose of SQL is to store , retrieve and maintain the integrity of data. It...

BSavoie (12/31/2011)

---

I appreciate the concept, and I can definitely go that direction, but forcing developers (of which I am one) to use the sprocs and not the tables directly can...

If somebody has already truncated the table and auditing is not in place then it’s difficult to track the user. If it’s just a thought & you want to safeguard...

Per BOL:

As modifications are made to the data in the base tables, the data modifications are reflected in the data stored in the indexed view.

For More: http://msdn.microsoft.com/en-us/library/ms187864.aspx

BSavoie (12/31/2011)

---

Thanks Dev. I hear ya. I like that plan, but what would be the best way to enforce the the "two members per team" rule on the server side?...

Start with Normalization Principles...

http://en.wikipedia.org/wiki/Database_normalization

No easy way. Confirm the IP with your team & document it at a safe place.

BSavoie (12/30/2011)

---

Thanks SQLRNNR.

That was definitely my first thought, but it doesn't really enforce the "two members per team" rule; whereas the other way around enforces it quite explicitly.

Maybe I...

ROFL :hehe:

It depends on various factors. For example network bandwidth, server utilization, RAM, the table structure itself and calling query. We can’t guess with the minimum information provided by you.

Performance Tuning...

Your table is badly designed. Day column should appear in rows it would make your query a lot easier.

SELECT COL_NAME

FROM YOUR_TABLE

WHERE DAY=’SUNDAY’

If you can’t change the table design, you should...