Monday, July 28, 2014
 
 

Understanding SQL Server 2008 Objects

In this module, you will learn the following:

  • Tables are the main objects that store data
  • Indexes, views, stored programs and other objects are the support structures
  • Various table types compared based on data organization
  • Various index types compared
  • Native and non-native data type support
  • Block-level storage architecture

 

Working with Indexes in SQL Server 2008

In this demonstration you will see how to:

  • Create a query to view allocation units
  • Determine why multiple results for a single index might be provided





 

Working with Tables and Filegroups

In this demonstration you will see how to:

  • Create a table taking advantage of filegroups for different types data structures
  • Review the results using SSMS






Understanding SQL Server 2008 Indexes, Views, Stored Procedures and other Objects

In this tutorial you will learn about: tables are the main objects that store data; indexes, views, stored programs and other objects are the support structure; various table types compared based on data organization; various index types compared; native and non-native data type support; and block-level storage architecture.

 

Working wtih Geometrical Data in SQL Server

In this demonstration you will see how to:

  • Define geometric shapes
  • Define an organizational structure for a company
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM