Nothing new and you might have already noticed it, but i wanted this link here to stay for future reference.

MS presents the online SQL Server 2000 System Table Map.

Included in this document:

  • Log Shipping Tables in the msdb Database map
  • SQL Server Agent Tables in the msdb Database map
  • Database Maintenance Plan Tables in the msdb Database map
  • Replication Tables in the msdb Database map
  • Backup Tables in the msdb Database map
  • Systems Tables in the Master Database Only map
  • Systems Tables in Every Database map
  • Replication Tables in Each User Database map
  • Replication Tables in Each Distribution Database map

Pretty cool.

On a sidenote, a friend of mine pointed me to a post on a small performance test wrt sorting and filtering of custom collections on 1 million custom objects… Not bad. Not bad at all !