Anticlue

Slow response with alot of dbs in one SQL Server instance?

Back in January MS released this cool performance tweak to the sp_MSdbuseraccess stored procedure. If you are in an environment that has a lot of db's on one box, originally sp_MSdbuseraccess would check on each db the level of access you have. With the modified procedure, it checks to see the level of access you have only of the dbs you can access, instead of all of the dbs on the server.