I would say that as testing tools are easier and easier to use, developers are expected to do more unit testing. I am expected to have a test class for each sproc, with number of methods generally depending on the number of parameters.

That, however, does not mean that QA will not do their own testing without looking at what I tested and how. (After a while, they do not have to look anyway because they know me and they know how I go about things.)