blogs.conchango.com

Browse by Tags

• Katmai
• SQL
• SQL Server 2008

• SQL Server 2008 RTM

  SQL Server 2008 is out! All editions are on MSDN now except for Express, which should hopefully follow soon. Enjoy! Read More... Posted 06 August 2008 19:29 by David.Portas | 1 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• Update on T-SQL MERGE

  The MERGE syntax I used here has changed. In 2008 RC0 the "WHEN SOURCE NOT MATCHED" clause is replaced with "WHEN NOT MATCHED BY SOURCE" which is supposed to make the meaning clearer. Although MERGE is part of standard SQL 2003 it's worth noting that Read More... Posted 09 June 2008 18:21 by David.Portas | 0 Comments Filed under: SQL, SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 RC0

  SQL Server 2008 Release Candidate 0 (build 10.0.1442.32) was released to MSDN and TechNet subscribers on Friday. It should be available to everyone else very soon via the Connect site. http://msdn.microsoft.com/en-us/subscriptions/default.aspx http://technet.microsoft.com/en-us/subscriptions/default.aspx Read More... Posted 09 June 2008 17:50 by David.Portas | 2 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 November CTP

  CTP5 is available today! http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884 Jamie has already blogged about some of the new goodies in CTP5, which include Intellisense for Management Studio. Also new in this Read More... Posted 19 November 2007 18:37 by David.Portas | 0 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 MERGE

  MERGE is a new DML statement in SQL Server 2008. Microsoft have implemented the ISO SQL 2003 and 2007 standard MERGE statement (as seen in Oracle and DB2) and added some extensions of their own. In a nutshell, MERGE allows you to perform simultaneous Read More... Posted 14 November 2007 21:52 by David.Portas | 2 Comments Filed under: SQL, SQL Server, Katmai, SQL Server 2008

• A note on Updateable CTEs

  One of my regular gripes about SQL Server concerns the number of Transact SQL features that give nondeterministic results. Unfortunately SQL Server 2005 added to the list of those. One of the new ones is ROW_NUMBER(), which is strictly due to ANSI/ISO Read More... Posted 26 July 2007 21:47 by David.Portas | 2 Comments Filed under: SQL, SQL Server

• SQL Server 2008 June CTP

  The Katmai CTP goes public today. The download hasn't appeared on Connect yet but the link is here: http://connect.microsoft.com/sqlserver Microsoft is previewing Katmai at TechEd and there is also a webcast you can join from the TechEd site: http://www.microsoft.com/events/series/teched07.asp Read More... Posted 04 June 2007 15:16 by David.Portas | 0 Comments Filed under: SQL Server, Katmai

• SQL Server 2008

  Microsoft have officially announced their intention to have Katmai available in 2008. (The title of this post is nothing more than idle speculation. Katmai doesn't have an official name yet.) http://www.microsoft.com/presspass/press/2007/may07/05-09KatmaiPR.mspx Read More... Posted 09 May 2007 17:57 by David.Portas | 2 Comments Filed under: SQL Server, Katmai

• MVP Summit, SQL Server "Katmai"

  Last week I was at the MVP Summit in Seattle and Redmond, mainly learning about "Katmai" - the next version of SQL Server - from the SQL Server development team. The details of Katmai aren't in the public domain yet but some of the key themes Read More... Posted 25 March 2007 10:14 by David.Portas | 0 Comments Filed under: SQL Server

• Concatenation Aggregate

  In response to Jamie Thomson's T-SQL poser , here's one very efficient method of concatenation in an aggregate query. It uses the FOR XML clause to turn a result set into a string. SELECT DISTINCT id, SUBSTRING( (SELECT ','+name AS [text()] Read More... Posted 22 March 2007 09:30 by David.Portas | 0 Comments Filed under: SQL Server

• Trouble with CHECK Constraints

  ANSI/ISO SQL defines CHECK constraints very simply as: <check constraint definition> ::= CHECK <left paren> <search condition> <right paren> where <search condition> is a boolean expression, including query expressions. In Read More... Posted 19 February 2007 18:36 by David.Portas | 3 Comments Filed under: SQL, SQL Server