I concure regarding the age bit 🙂

One large advantage with XML is that the record count is .. well .. sort of unlimited.

Jason: May I ask for a a short example on how to do XML with nested replaces? I have no experience with XML in SQL. Okay. Found it, don't understand...

Jason: May I ask for a a short example on how to do XML with nested replaces? I have no experience with XML in SQL. Okay. Found it, don't understand...

Great as (for me) an introduction into the world of PowerShelling. In your text I think you syntactically need to to point out the values that need change e.g. "mailserver"...

Reply to satalaj: How about using a trigger on insert (and there copy the newly inserted records onto server b and delete the old ones). You have the pseudotables "inserted",...

What about @@CPU_BUSY and @@IO_BUSY

if you checked those two values e.g. every 10 seconds and the @CPU_BUSY had increased 8 seconds I would assume that it was running on 80%,...

Right again. Should have posted in the 2005-section. Didn't expect the post to point at filestreams.

You right. Learned about filestreams as late as yesterday, but alas, I cannot use it as the customers heavily rely on SQL2005 and streams is a 2008 thing.

In time they'll...

Thanks everyone. I'll look forward to the next articles. Hope you're alright down there (:hehe:). I can see it has been a bit shaky in Christchurch some 350km away.

Great article, great topic. I belong to the newcomer group and as such I would have liked to see how those rules you talk about, were executed. You move the...

.. glad I always try to avoid the use of subqueries in my applications. This was done by intuition as I didn't know of the tabs in Management Studio. I...