I found an article by Atif Shehzad which explained schema binding and indexed views very clearly. See it here:

http://www.mssqltips.com/sqlservertip/1610/sql-server-schema-binding-and-indexed-views/

From the article:

Be aware that if you do not use the...

Did you want something that just DISPLAYS the first twelve characters of the cc number as asterisks, or did you actually want to wipe the first twelve characters out of...

Nice question. Although I can't see why anyone would try to do this. :hehe:

This is a fantastic post, and as a newer DBA, it really clarified exactly how the ROW_NUMBER/PARTITION BY function works. The solution is a perfect fit for me on...

Nice question. The discussion from the Aug. 3 question made this one easy. I learned something I didn't know last week, and I used that knowledge today. 🙂

I think that will do it. Thanks. 🙂

Thanks for your help, I got it working with your suggestions. 🙂

Very cool. My results were 1080 duplicate numbers, each appearing twice. No number returned 3 times. Out of 3 million, that's 99.96% unique. 🙂