Browse by Tags

All Tags » Katmai (RSS)

Getting more than 1024 columns in a table

The create table statement doesn't allow you to create a table with more than 1024 columns. So how do you do it. You have to create the table and then add them after the fact. [21/9/2008 Thanks to Kalen for pointing out that you can if you create...
Posted by simonsabin | 4 comment(s)

SQL Server 2008 UK Usergroup London Launch event

SQL Server 2008 UK Usergroup London Launch event As part of the SQL Server Launch wave we are holding a usergroup meeting to celebrate the launch (not RTM). We're going to run this as an open session so you'll be able to ask us to cover the areas...
Posted by simonsabin | with no comments
Filed under: , , ,

SQL Server 2008 - Breaking bug

If you are using CTP6 of SQL Server 2008 and want to use Integrated Full Text and find it is not working. You might get timeouts or other general errors. It could be due to an account that iFTS uses. iFTS does some stuff out of process for security and...

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you...

SQL Server 2008 - HierarchyId whats the point?

I've recently been deliverying training sessions on SQL Server 2008 and doing launch events. The training covers all aspects of SQL Server development. For most features I can provide a strong argument for the feature with the exception of one. HierarchyId...
Posted by simonsabin | 1 comment(s)
Filed under: ,

SQL Server 2008 Spatial - Got a question?

If you got a question about the spatial stuff in SQL Server 2008 make sure you visit the msd Spatial forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1629&SiteID=1 The guys from the team that developed it hang out there so you should...

SQL Server 2008 Filestream : Why?

Why would you want to use filestream in SQL Server 2008? The files you store using filestream in SQL Server 2008 are not accessible directly using the normal io methods.Instead you have to make a SQL call to get a pointer which you can then use with normal...

Katmai Spatial - Whats a dimension?

When you read the specs for the spatial stuff (BOL has some incorrect links) some of the methods talk about min and maximum geometry dimensions. I must have been doing too much analysis services stuff and for the life of me I couldn't figure out what...
Posted by simonsabin | with no comments

Katmai Spatial - What's a geometry

Following on my previous post on discovering the spatial types I mention that one of the aspects to understand is the different types of geometries. Point Fairly this is obvious its a single spot that has an X and a Y co-ordinate. Multi Point A group...

Katmai Spatial - First thoughts

I've been doing some work with the Spatial types in Katmai and these are my first thoughts. The first thing is that the data type is the same used by SQL as used in your .Net code. So what does that mean, · You use the same methods, which is great...
More Posts Next page »