in

SQLServerCentral.com

The largest free SQL Server community.
All Tags » New Features (RSS)

Browse by Tags

  • Unmatched Nodes in XQuery

    In a previous post I talked about performing "inner joins" in XQuery. The basic idea is that the inner join is simply a special case of a Cartesian product, or "cross join". In this post I'm going to briefly look at another common SQL-style join condition that can be duplicated...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 02-24-2008

  • SQL Server 2008 Feb. CTP (CTP-6) Available

    Ladies and Gentlemen--Start Your VMs! Microsoft has released SQL 2008 CTP 6 for download at the Connect Website: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395 . There's a whole laundry list of new features in this CTP: - iFTS - filtered indexes - MS Word rendering -...
    Posted to Pseudo-Random (Weblog) by Mike C on 02-19-2008

  • Create a Dynamic Logging Trigger With XML

    One of the more common uses of triggers is to create data manipulation language (DML) logging functionality. Essentially you can intercept and log inserts, updates, and deletes to tables. In the simplest case it's enough to know that one of these operations has occurred on a table, the date/time...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 01-26-2008

  • Welcome to Pro SQL Server XML

    Hi everyone, in this blog I plan to discuss the new SQL Server 2005 and SQL Server 2008 XML features. While I have several topics I plan to cover already, if you have specific SQL Server + XML related questions, feel free to contact me via this blog and I'll try to answer, or at least help you get...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 01-21-2008
Page 1 of 1 (4 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems