Tuesday, November 14, 2006 - Posts

Replication - InProcLoader has been deprecated

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Replication - InProcLoader has been deprecated
The new RSS feed is here

Something I learnt in the PSS session yesterday was that the inProcLoader option for distribution agent is a deprecated feature. This option makes the bulk load of data when distributing a snapshot run in process, i.e it uses BULK INSERT.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Replication - InProcLoader has been deprecated

posted Tuesday, November 14, 2006 6:35 PM by SimonSabin with 0 Comments

Referencing Parent nodes in XQuery is expensive

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Referencing Parent nodes in XQuery is expensive
The new RSS feed is here

 Recently a post on a newsgroup caught my attention. "OPENXML vs XQuery Performance", it caught my attention because I did a bucket load of performance testing of OPENXML way back when for SQL Server 2000 XML Distilled and hadn't touched XQuery really.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Referencing Parent nodes in XQuery is expensive

posted Tuesday, November 14, 2006 5:32 PM by SimonSabin with 0 Comments