Thank you Jeff,

we are watching that righ now. We just need to run some procs to populate some tables and then "sync". We will see what exactly will/wont...

Henry and Steve

The databases are on Simple mode def. and Yes my loads are every hour and. I load between 1 and 3 millions of records (and it will grow...

Thank you Steve. I will pay attention to that.

and Yes, we need to run some procs so CE is not our solution. 😉

Definitely, SQL Express Edition is the best solution for us.

Thank you everyone

Thank you all,

My end user is not our developers, are the users that manage the application. I'm thinking about the Express Edition. I never heard about the compact one....

Thank you Lutz

It works !

I will take at look at your article.

thank you again

Hi Vincent,

Your article is great for me, it’s the first time I’m working with data marts. I just created my first environment (still in the development/test mode). I read your...

Thank you Brandie

And Yes you are right. Thank you to put the right words. I couldn’t explain it better. You are correct 😀

I didn’t find it. This happened in October 2009. Then I fixed it with the code that you see now. The index is “blocked” because the column that is referred...

With process I meant this stored procedure. Part of my maintenance plan for Indexes is to check the percentage of their use (fragmentation) and Rebuild or Reorganize them. But, sometimes...

I do it in order to rebuild or reorganize an index that is block during the process.

is that wrong to do?

Thank you everyone.

It works perfectly 🙂

I forgot to mention that my database has the Full Recovery Model, but I dont need the up to date data. Im planing to use the last full backup of...

Pretty easy

Just add another string variable with the other path and get the array (same like the other path)

and all the files will be added into the Object Variable

Thank you

guys,

this option works perfect in my package. I dont need to process all the files, only those than are 1 day older to today. 🙂

I only need to set...