Creating indicies on views

Because runsaturday maintains two user databases - one for yaf and one for dnn - I wanted to create a lookup table from one set of userids to the other.

And the easiest way of doing this automatically was a view with an index.

But to create the index on the view - I had to remember the SchemaBinding trick - see http://www.mssqltips.com/tip.asp?tip=1610 for more information about schema bound views.

The Joel Test

I've not really seen this before - but just been sent it within the UK MSDN Flash today - http://geekswithblogs.net/iupdateable/archive/2009/08/05/uk-msdn-flash-poll-how-did-your-software-team-score.aspx - interesting stuff:

The Joel Test

1. Do you use source control?
2. Can you make a build in one step?
3. Do you make daily builds?
4. Do you have a bug database?
5. Do you fix bugs before writing new code?
6. Do you have an up-to-date schedule?
7. Do you have a spec?
8. Do programmers have quiet working conditions?
9. Do you use the best tools money can buy?
10. Do you have testers?
11. Do new candidates write code during their interview?
12. Do you do hallway usability testing?

And once you have answered those questions, share with the rest of us how you scored. 

I think I score a 8 or 9... I'll let you guess which ones I don't do... and which one I half kind of do.