Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server Rocks!

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Archives: January 2012

Introduction to XML DML (Part 2) - Using the modify() method: replace value of

This is the second part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an XML document. This part, starting at the absolute basics, will cover the ability to update data in… Read more

0 comments, 3,982 reads

Posted in SQL Server Rocks! on 26 January 2012

Introduction to XML DML (Part 1) - Using the modify() method: insert

This is the first part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an XML document. This first part, starting at the absolute basics, will cover the ability to insert data… Read more

0 comments, 4,787 reads

Posted in SQL Server Rocks! on 16 January 2012

Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

This is a revised post of an original article that I first published in December. Even though I thought that I was very meticulous in my research, something was pointed out to me that I was totally unaware of - Unicode character expansions. So apologies to the community with regard… Read more

0 comments, 20,896 reads

Posted in SQL Server Rocks! on 9 January 2012