This is a scary T-SQL post with some ugly code and unfriendly variables as the result of a quick hack to answer a StackOverflow question [http://stackoverflow.com/questions/13761768/how-to-find-column-and-table-name-using-columns-value-in-sql-server/13763701#13763701] : > In T-SQL, if just know…
Daniel Wertheim
This is a follow up on my post that I wrote this weekend: “SQLGeography in SQL Server 2012 – Polygon must start on correct position? [https://danielwertheim.se/sqlgeography-in-sql-server-2012-polygon-must-start-on-correct-position/] “, you probably want to go and skim it through and then come back.…
Daniel Wertheim
This week I saw a tweet from Julie Lerman [https://twitter.com/julielerman/status/273811980660404224] (@julielerman) which caught my interest: The error report found here [http://connect.microsoft.com/VisualStudio/feedback/details/772444/sql-server-object-explorer-locks-databases#tabs] , says: &…
Daniel Wertheim
I’ve been working with some simple spatial data lately. In one use-case, the user marks a polygon by using an iPad or iPhone in field and walks around storing points (coordinates), which after at least three points, forms an area (the first coordinates are also used as the last to close it). I’m usi…
Daniel Wertheim
> The N+1 is evil. I want referential integrity. I want... "Hold it right there Mr!" A document-oriented Db (DOD) is not an RDBMS! If you are having an N+1 scenario or feeling a pain with references, you should probably first have a look at your model and your chosen data-persistence…
Daniel Wertheim