c# - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » c# (RSS)
22 February 2008 00:58

SQL Reflector

In the user group meeting today I mentioned an AddIn for Management Studio that did reflector on the assemblies in the database. I was either confused as I don't seem to be able to find the management studio add in. What I did find was a plugin for Reflector...
Posted by simonsabin | with no comments
Filed under: ,
20 February 2008 09:40

SQL Server 2008 – iFTS Transparency – dm_fts_parser

SQL Server 2008 – iFTS Transparency – dm_fts_parser In the next in this series of posts on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser. Wow thats a cool function name what does it do Simon? Well in my first...
Posted by simonsabin | with no comments
Filed under: , , ,
04 January 2008 17:58

SQL Server 2008 Spatial - Which is faster WKT or WKB?

I've just posted two methods for creating geometries in client code. The examples use Stylus points from an ink canvas but any collection of points will go. After doing that I ran some tests to compare the two. I found that in generally the WKB method...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
04 January 2008 17:34

SQL Server 2008 Spatial - Converting from Ink Strokes to geometries

The following snippet will convert an strok collected using an Ink Canvas in WPF to a LINSTRING geometry. The first uses the Well Known Text format WKT. //Text representation of a line is LINESTRING (x1 y1,x2 y2 x3 y3....) //create an string array to...
Posted by simonsabin | with no comments
Filed under: , , , , ,