Browse by Tags

SQL Server 2008 Spatial data - geography & geometry, all in one
20 March 08 11:24 AM | ssqa.net | with no comments

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: blog, sql server, ssqa, 2008, data, new feature, spatial

SQL Server scrollable server cursors, use them carefully!
10 March 08 07:09 AM | ssqa.net | with no comments

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be...

Filed under: api, sql server, server, performance, sample, tsql, data, plan guide, result set, cursors, dba