SQL Server version is the same:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition...

Thanks for your reply.

I need to parse a string using regular expressions, .NET allows to do it easily.

Sorry, I found out...

if object_id('tempdb.dbo.#Temp') is not null

drop table dbo.#Temp

CREATE TABLE #Temp (col xml)

INSERT #Temp (col)

select '<?xml version="1.0"?>

<soap:Envelope

xmlns:soap="http://www.w3.org/2001/12/soap-envelope"

soap:encodingStyle="http://www.w3.org/2001/12/soap-encoding">

<soap:Body xmlns:m="http://www.example.org/stock">

<m:GetStockPrice>

<m:StockName>0.018</m:StockName>

</m:GetStockPrice>

</soap:Body>

</soap:Envelope>';WITH XMLNAMESPACES ( 'http://www.w3.org/2001/12/soap-envelope' as "soap", ...

Did I get that right - if I call DBCC DROPCLEANBUFFERS without calling CHECKPOINT, there is a risk of data loss?

I thought SQL Server wrote changes to disk immediately..

Thank you.

How can I clean cache, for example, when I want to compare perfomance of two queries and I want to know how many physical reads will be for each...

I am reading articles and that book from redgate - and it is much better now, thank you guys. And I hope I will be able to read execution plans...

I hope, that this is the temporary solution, otherwise you have to change your code 2 times a year. Moreover, you can not get valid date in the past.

Thank you very much guys!

Your posts are very useful.

CLR UDF will help you