The following example creates a second spatial index, SIndx_SpatialTable_geography_col2, on the geography_col in the SpatialTable2 table. The example specifies GEOGRAPHY_GRID as the tessellation ...

How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. ... For example, your commands might read like the following: ...

Through SQL one can create and delete tables. Here are some commands: CREATE TABLE - creates a new database table ALTER TABLE - alters a database table DROP TABLE - deletes a database table CREATE ...

Determine space for the temporary mapping index. In this example, the old bookmark is the row ID (RID) of the heap (8 bytes) and the new bookmark is the clustering key (24 bytes including a ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...