blogs.conchango.com

SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are going to see in future versions. I was chatting to Rob Farley recently and we started to wonder ...

''Why the <insert your favourite expletive here> doesn't SSIS support C# for the script task and script component?''   I've heard the above complaint, in various different ways, many many times over the past 18 months since SQL Server 2005 was released. Its a valid complaint to which there is a valid answer (which I'm not going ...

SQL Server 2005 includes the WITH CUBE and WITH ROLLUP syntaxes that are used to display summary information for combinations of columns in the GROUP BY clause. That's useful functionality but it didn't provide particularly fine-grained control over what summaries were returned. Essentially it was all-or-nothing. In katmai, the next ...

A very short post here showing some of the new T-SQL constructs in katmai. Check out the following code snippet:declare @i int = 1;set @i += 1; create table t1 (col1 int);insert t1 values (@i),(@i+1); There are actually three syntax enhancements in there. Can you spot them? No? Let me fill you in:Initialisation at the same time as ...