thx guys,

these are the answers I expected (also the one about Oracle having more corruption issues than SQL :-D)

We're already using raid protection, frequent trn log backups, etc. so we're...

Hi George

thanks for the prompt reply. What Oracle actually does is writing the same info to 3 different files (preferrably of course on different drives) so when one file is...

I'm missing some things here (principal, job owner, ...). I doubt this (and the link to the summary on codeproject) is the recommended way if you want it to be...

lol 🙂 Peace man.

Did I mention the word "feature" in my post...? You're taking this too far. I was merely trying to express my opinion/feelings. I respect yours and that of others in...

Gary, I did'nt say EVERYTHING ends up in IL. The .NET languages end up producing IL...

Everyone is right in this one...

A dozen years ago (hmm.. make that 2 dozen :)) I graduated as a C/C++ developer. Even then Basic was mocked with. But not laughed...

Great article, thanks! Will help me to get started

But at the end you wrote: "And that's it! Running the package deletes all backup files that haven't been restored except the...

The OPENROWSET code and the examples are interesting, but I wonder about performance.

BTW, I'm always reluctant to change system parameters (in this case ad hoc dist queries) to achieve...

Hmm, I think I'll start with 5Gb for the first instance (now consuming over 7Gb) and 1.5Gb for the second instance.

Why...? 🙂

1. I suspect the instance that's now consuming 7Gb...

Hi guys

thx so far for the repsonse!

Indeed, I forgot to answer the AWE question. AWE is not enabled but it's a 64bit instance.

So, I guess I'll just restrict...

total memory is 8Gb. SQL instance 1 is using about 7.5Gb of it. I suppose if we add memory it would even grow so can I assume the server is...

thx a million Andrew! Your assumptions were right by the way. Actually this question came to me from via a colleague dealing with the SCOM 2007 database (I will not...

Hi again

oh yes, I forgot XML strings are not displayed in the web page

This is what it should be:

&ltparameters&gt&ltparameter0&gtKevin&lt/parameter0&gt&ltparameter1&gtoff&lt/parameter1&gt&lt/parameters&gt

I was thinking about XQuery as well but I'm not too...

I don't really understand how this reduces server resource utilization except for network traffic. If a user is paging through the data screen, only a screen full of rows (10,20...)...