Agreed. I believe that the change tracking functionality is designed primarily to act at a lower level of granularity, so that individual row changes to a table can be audited,...

Hi jongy,

I'm afraid I am not very familiar with change tracking.

I also skim read the article you listed, but can see no mention of the CHECKSUM functions discussed in this...

Working now on my iPhone, but it seems you must include the trailing slash (/) at the end of the URL to avoid a 404 error:

http://www.sqlservercentral.com/mobile/qotd%5Bb%5D/%5B/b%5D

Regards.

Yes 404 from iPhone also.

Shouldn't the line:

"The world of software development will change radically once somebody starts building applications in a drastically more consistent way"

..instead read:

"The world of software development will change radically once...

Excellent and very throught provoking series.

Do we think the mix up of RULEOFF/RULEON in SQL 2005 was a deliberate ploy or purely accidental by the MS developers?

😉

Thanks Steve. (Doh!) 😉

This works. (can probably be simplified)

;WITH WordsFromPhrases(Textid, WordPos, Word, NewPhrase)

AS

(

SELECT TextId, 1 AS 'WordPos', SUBSTRING(Data, 1, CHARINDEX(' ', Data, 1)) AS 'Word',

REPLACE(Data, SUBSTRING(Data, 1, CHARINDEX(' ', Data, 1)), '') +...

Revised XPath query that would work for above namespace is:

SELECT @x.value(' declare namespace NS="http://www.mycomp.com/lbg.paris.load.bulkdealcomponentinsert.xsd"; /NS:BulkDealComponentInsert[1]/NS:Deal[1]/NS:OrgCode[1]', 'varchar(100)') AS OrgCode

Hope this helps,

Cheers,

One potential problem and improvement that could be made to the function.

Support for namespaces?

For example:

DECLARE @x XML

SELECT @x = '

<BulkDealComponentInsert xmlns="http://www.mycomp.com/lbg.paris.load.bulkdealcomponentinsert.xsd" RequestId="150134" BatchNum="25">

<Deal DealCode="2862868LN|SWAPTION" DealVersion="10">

...

Sebastian,

This is very powerful stuff!

Very nice to be able to automatically produce XQuery paths statements.

Thanks,

Excellent article. Well written with clear examples.

Jesus,

I'm not completely sure what you are asking.

Could you elaborate please?

Many thanks,

Lawrence

JJ B,

Many thanks for your post and kind comments.

It's certainly been a valuable process for me to discover the performance limitations of ROW_NUMBER(), and be able to demonstrate that they...

All,

With Henrik's input, I've been able to deduce that the following Index improves the "Latest Edition" query considerably:

CREATE UNIQUE INDEX ix_Books_Test1 ON dbo.Books(BookTitle, BookEdition DESC) INCLUDE (BookPublishDate, BookAuthor)

This is an...