Simon Ince's Blog

Ramblings of a gadget freak

Browse by Tags

Tagged Content List
  • Blog Post: Know what your SQL Database is doing

    Ryan Simpson is one of my colleagues in the UK ADC team... and he has recently blogged a great little post about some of the tools we use with customers when we have them in Reading for a scalability or performance lab. Make sure you check it out here; http://rynsim.spaces.live.com/blog/cns!1DA5A63F849536B6...
  • Blog Post: Flattening XML Data in SQL Server

    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 ( RecordId INT IDENTITY ( 1 , 1...
  • Blog Post: Procedural versus Set-Based SQL

    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 SQL tasks can make to the performance and scalability...
  • Blog Post: Mapping two Tables to one Entity in the Entity Framework

    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 to get this working. It seems a common thing...
  • Blog Post: 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 extract that data. If you’ve not read them, you can find them here and here . In SQL Server 2008 we have a brand new shiny data type...
  • Blog Post: Row Versions: What’s that all about?

    Intro I did some work with a customer recently to understand what the different Isolation Levels they could use in SQL Server 2005 meant to their system. Of course, we’ve all seen the standard isolation levels that have been around for ages, but SQL 2005 introduces two new options; · Read Committed...
  • Blog Post: Common Table Expressions, Reversed

    There was an interesting question left on my last post entitled Hierarchies WITH Common Table Expressions . Basically in this post I showed a couple of ways that you can use SQL Server 2005’s new “Common Table Expressions” (the “WITH” SQL statement) to retrieve a subset of a hierarchy of data. The question...
  • Blog Post: Hierarchies WITH Common Table Expressions

    Storing hierarchical data in a database is a very common task, and SQL Server 2005 brings us Common Table Expressions (CTEs) – a very useful tool for retrieving such data both elegantly and efficiently. I haven’t actually used these before, and they came to mind during a session with a customer, so I...
Page 1 of 1 (8 items)