Hello All, I am looking for some general advice concerning views vs. tables.  I have several processes for which I have created multiple views.  In other words, View 2 depends on View1 and so on.  Some of these are nested 6-8 deep. I had some initial difficulty with unexpected join results (SQL choosing a different join than what ...

It’s well known that bookmark lookup (aka key lookup in case of a clustered index) is not cheap, especially when it comes to retrieving a lot of data. So I’m not going to rehash the pros and cons of bookmark lookup or why bookmark lookup is expensive. But I’ve noticed that when it comes to discussing bookmark lookup, all the literature seems ...