If you really want to query fast put an clustered index on the columns you want to query on. If you want your clustered index to be nice and healthy...

"query performance is MUCH more important than the performance of the inserts, so i'm thinking of putting IDItem first. But when i do that my indexes will get fragmented every...

post this item in the Integration Services and you'll get more response hopefully.

I know you can set security in SSIS packages on several levels and configuration of the packages can...

In SQL server:

Under management - Database mail- You need to setup a new e-mail profile and corresponding smtp account

You can use the stored procedure to test if its working:

sp_send_dbmail

for more...

SQL Management Studio -> right click: Database Email (under management) -> Manage database mail account and profiles ->

Here you can create a new profile or modify an existing one....

By default queries are performing better only to select the columns you need, and put the appropiate indexes on them. If you want to learn more about indexes, you can...

In SSIS you can use send mail task (under control flow items) or the execute SQL task and you can use: xp_sendmail (a stored proceure to send an email)

Can you tell me what the size is of your database? And what is the activity on your database? Are there processes / sql statements that need tuning, applying indexes...

@Piet, i am curious how it is going and how have you implemented your maintance plans / backup strategy?

And if the error found there is : Unable to start mail session (reason: No mail profile defined)"

Then: In SQL server Management Studio -> SQL Server Agent -> properties ->...

@kraaitje and edwin: are you gonna share your experiences with us??

No, normally you don't have to run update statistics after creating an index. It should have effect on your SQL immediately. Perhaps have a look at your query with execution...

Problem solved! Just found the solution for: "Unable to start mail session (reason: No mail profile defined)"

Yeeha!

In SQL server Management Studio -> SQL Server Agent -> properties -> Alert...

@sugesh: Thanx for your reply. It sounds like a nice solution, and in some cases it is a nice solution.

But for the most part we don't want...

Can't do that with replication.. You'll need a dts package with that and transform data.