Browse by Tags

SQL Server 2008 Spatial data - geography & geometry, all in one

Published 20 March 8 3:32 AM | SSQA.net

Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric...

Filed under: sql server, indexes, 2008, labs, data capture, spatial, data type, links, new features, geometry, geography

SQL Server indexing - when to reorganize or rebuild?

Published 21 January 8 4:30 AM | SSQA.net

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...

Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize