Browse by Tags

All Tags » SQL Server 2008 (RSS)
17 December 2010 02:08

Make huge space savings by using SPARSE columns

I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
03 December 2010 22:17

Restricting logons during certain hours for certain users

Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
17 November 2010 00:16

Trace Flag 610 – When should you use it?

Thanks to Marcel van der Holst for providing this great information on the use of Trace Flag 610. This trace flag can be used to have minimal logging into a b tree (i.e. clustered table or an index on a heap) that already has data. It is a trace flag...
Posted by simonsabin | 2 comment(s)
Filed under: , , , ,
29 October 2010 10:22

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

When writing CLR code for SQL you need to handle nulls. You can do this in two ways, either your data types are nullable or you configure your functions to always return null when a parameter is null. The last only works for some objects and so understanding...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
21 October 2010 00:57

How to downgrade Integration Services 2008 packages to 2005

Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
04 August 2010 22:16

SpatialViewer Beta 3 – new release

Just released an updated version of the spatial viewer http://spatialviewer.codeplex.com   This is a C# app that allows you to draw shapes and then get the spatial representation for them in WKT format. It also allows you to manipulate shapes union...
Posted by simonsabin | with no comments
Filed under: , , ,
19 May 2010 19:22

Scream if you want to go faster

My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
05 April 2010 14:01

Spatial data in the UK

I am just loving the fact that the Ordance Survey has now released a huge amount of data that can be used freely. I’ve downloaded the Panorama (tm) data http://www.ordnancesurvey.co.uk/oswebsite/products/land-form-panorama-contours/index.html . which...
Posted by simonsabin | 2 comment(s)
Filed under: ,
26 March 2010 18:21

Enabling super single user mode with SQL Server

I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
11 March 2010 20:20

SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
More Posts Next page »