Hello,

Thanks for great article. I have one question.

Example "CHECKSUM may fail to detect a change" works diffrent on my SQL Server. It returns:

Before Change | After Change

-546463845 | 991901348

Is it...

He everyone,

I have read your discoussion about dropping articles and snapshot creation and still have a few questions;

1. Is this true that after drop an article (sp_dropsubscription + sp_droparticle) I...

I have just did the following:

1/ scripted all tables (by SSMS Tasks->Script) from my orgin DB

2/ execute Tool_ScriptDiagram2005 in my orgin DB

3/ created new test DB

4/ in test DB: refresh...

Yes, I've transferred one of my diagrams to another SQL Instance.

Try this: http://www.codeproject.com/KB/database/ScriptDiagram2005.aspx

Thanks for help!

Experimental reason 🙂 I want to measure how much slower is XML type than T-SQL, and by the way learn XQuery 🙂

Thanks for yuor answer.

Unfortunatelly it isn't exactly what I want, because I want correctly sorted names- BY StartDate.

Look at the comparison:

SELECT tab.c.query('

for $i in (EmploymentHistory/Position)

order by fn:string($i/StartDate) descending

return (fn:data($i/@Name))')

FROM @xml.nodes('/root')...

In my code I use sorting in XQuery, and this is part of much more complicated example, so I still want to limit elements in XQuery 🙂

This is the schema...

It doesn't works- I want to limit XQuery results; not T-SQL