Browse by Tags
All Tags »
SQL (RSS)
Whilst at Q-Con a few weeks ago someone asked me about how to map two database tables to one entity in the Entity Framework... something a lot of people want to do at some point or another. At this point I must thank Chris Barker for pinging me some links
Read More...
If you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational data? It turns out this is quite easy... Setup Let’s create a simple table to hold our data; CREATE TABLE XmlSourceTable
Read More...
During my day job I come across customers that are struggling to make a system perform to the expectations of their users, and they often see this as a SQL Server problem. This post is designed to demonstrate how much of a difference your approach to
Read More...
This post by Simon Ince explores the topic of Hierarchies with HierarchyID in SQL 2008. If you’ve been following my blog you should remember a couple of posts about hierarchical data in SQL Server, and how Common Table Expressions can be a great way to
Read More...
