At the moment these notes are incomplete
See also my 2072 and 2073 Study Notes
Each explicitly named stored procedures, extended stored procedures, or command line utilities, relevant T-SQL commands, and, where referenced:
Quick jump to a Module:
| Name of Tool, Command, or System Object | Purpose of Tool, Command, or System Object | Where referenced in MS2072 by Module |
| Module 1, Intro to Transact-SQL | ||
| Module 2, Using Transact-SQL Tools | ||
| Module 3, Retrieving Data | ||
| Module 4, Grouping and Summarizing Data | ||
| Module 5, Joining Multiple Tables | ||
| Module 6, Working with Subqueries | ||
| Module 7, Modifying Data | ||
| Module 8, Querying Full-Text Indexes |
|
|
| sp_help_fulltext_catalogs | Returns the ID, name, root directory,s tatus, and number of full-text indexed tables for the specified full-text catalog. | |
| sp_help_fulltext_tables | List of tables enabled for full-text indexing. | |
| sp_help_fulltext_columns | List of columns enabled for full-text indexing. | |
| COLUMNPROPERTY | IsFullTextIndexed | |
| DATABASEPROPERTY | IsFullTextEnabled | As in, select databaseproperty('Northwind','IsFullTextIndexed') |
| INDEXPROPERTY | IsFullTextKey | |
| OBJECTPROPERTY | TableHasActiveFullTextIndex | |
| FULLTEXTCATALOGPROPERTY | PopulateStatus ItemCount IndexSize UniqueKeyCount LogSize PopulateCompletionAge |
|
| FULLTEXTSERVICEPROPERTY | ResourceUsage IsFullTextInstalled |
|
| Module 9, Introduction to Programming Objects |
|
|