Came across a neat tool today – I am not huge fan of Linux but I do like the ability to have multiple desktop spaces where you can divide up your work and maximise screen real estate. Well, you can now do this in Vista (or XP). Try this out for yourself , its a […]
Do you need to use the excellent RMLUtilities (in particular ReadTrace) against SQL Server 2008 trace files? Well, ReadTrace does not support 2008 yet but if you need to convert your files , please try this free utility: Trace Convert This is a command line tool, simply jump to the command line and use as […]
One neat feature of SQL Server 2008 is the ability to see how fragmented your fulltext indexes are. By running the following you can see how many fragments you have. SELECT * FROM sys.fulltext_index_fragments The rule of thumb is that if you have between 30-50 fragments per table you should be thinking of reorganizing (REORGANIZE) […]
Just wanted to say a big thank you to Simon Sabin and Tony Rogerson for a very enjoyable event. I really enjoyed the demo on Spatial support and Simon’s very own Spatial Viewer. We have lots of exciting times ahead with the release of SQL Server 2008. You can download the viewer mentioned in this […]
In case any sql dev’s wasn’t aware, TEXT and NTEXT will be deprecated. Seems like SQL 2008 could be the last version to have them, in any case I guess we should all think now about changing columns to VARCHAR/NVARCHAR(max) sooner rather than later.
This is potentially very useful if you are intending to use Change Tracking. It is possible to set a context (“hey, all these changes were done as part of this process”). This can easily be done by DECLARE @originator_id varbinary(128); SET @originator_id = CAST(‘SSIS’ AS varbinary(128)); WITH CHANGE_TRACKING_CONTEXT (@originator_id) UPDATE MyTable SET MyLocationId = 1100 […]
Well, kind of. The guys behind the fantastic Camtasia Studio (techsmith) has released a fine free alternative which seems to be in beta at the moment. The product is called Jing and after play testing it for a while it seems to be very snappy. It can record video (into SWF files) or capture images. […]
I have been doing some benchmark/tracing for Katmai and came across the excellent RML Utilities. However I wanted to blog about a bug in this which has meant that the ostress tool couldn’t be used to replay the trace. ReadTrace allows you to read a trace file and output/split this into RML files (one per […]