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
Tag Archives: AppliedSQL
Applied SQL: sys.objects
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!