I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning of index names? Nope. But I keep doing it because... I'm creating an index and as I type it, I put ix at the beginning.

One are where I think it's possibly usefule, but not carved in stone, is as a means to differentiate betwee views that are meant to be known as views and views that are meant to be known as tables. That's the one place I can think of that this makes a substantial difference. Other than that, naming a proc sprGetMyData or GetMyData... neither one makes a difference in terms of actual programming or performance. It just becomes a matter of convenience to break the update, spu, from the reads, spr, from the deletes, spd, from the inserts, spi or spc, but it really doesn't matter a whit.