as jeffrey sais...

as far as I can remember (think I read this in an article by paul randall sometime ago) a db is in simple mode until a data backup...

Hi Eric

nope. Never really found the cause. Since I got no further response and it wasn't really critical didn't put more effort into it. Too bad but stuck on other...

Hi Ali

thx for the reply. However, I posted this topic after reading that article 🙂

What I'm confused about is that there's more plans in the cache and more compilations occurring...

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...