Jen McCown from midnightdba.com started a useful (to me anyways) set of homework assignments called Applied SQL. Each post has a homework assignment for us. This first one has been useful to me in order to make myself read Books Online and understand where information comes from, rather than just running a script when I want information to get information out of the black box. Continue reading
System tables have lots of interesting and useful information stored on all facets of SQL server. Generally speaking, whenever I find a script that shows useful information, I store that script away for future use. I then run the script whenever I need the information without really thinking about it. Jen McCown from midnightdba.com started a useful (to me anyways) set of homework assignments called Applied SQL. Each post has a homework assignment for us. This first one has been useful to me in order to make myself read Books Online and understand where information comes from, rather than just running a script when I want information to get information out of the black box.
Assignment 1 is looking at the sys.objects system table. Below is my homework, maybe I’ll get some bonus points for sorting my results too!