Hi Rehman,

You can check out "Beginning Spatial with SQL Server 2008" (http://www.amazon.com/Beginning-Spatial-Server-Experts-Voice/dp/1430218290), which has chapters covering the following topics:

1. Defining Spatial Information

2. Implementing Spatial Data in SQL Server 2008

3. CLR Datatypes and the .NET Framework

4. Creating Spatial Data

5. Marking Out Features Using Virtual Earth

6. Importing Spatial Data

7. Geocoding

8. Syndicating Spatial Data

9. Interactive Web Mapping

10. The Spatial Results Tab

11. Examining Spatial Properties

12. Modifying Spatial Objects

13. Testing Spatial Relationships

14. Spatial Indexing

However, you won't find anything about working with 3D geometries, in this book or any other - although SQL Server allows you to define coordinates in 4 dimensions (x, y, z, m), all of the inbuilt methods only operate in two dimensions (the flat planar surface of the geometry datatype, or the ellipsoidal surface of the geography datatype). z and m can be stored, but are not used unless you want to write your own custom methods.