GilaMonster (8/29/2013)

---

Was the OP talking about large bulk inserts? They're not going to improve the...

HanShi (8/29/2013)

---

To write data when the instance is started you can create a job with a schedule to be executed "Start automatically when SQL Agent starts". Maybe you should include...

Brandie Tarvin (8/29/2013)

---

David Burrows (8/29/2013)

---

Jan Van der Eecken (8/29/2013)

---

Now, that's interesting. Was looking for a book on SSAS on Amazon. Found "Professional Microsoft SQL Server 2012 Analysis Services with MDX...

GilaMonster (8/29/2013)

---

Koen Verbeeck (8/29/2013)

---

And how can you improve a query? By updating...

Compression leads indeed to more CPU utilization, but if the CPU isn't under pressure, this shouldn't be a problem. Because the data is compressed, you need to use less IO...

That means it ran just fine.

The easiest method to do this is to run this query on Oracle and see which functions error out.

Use Google to find the Oracle equivalent. (for example: convert sql server...

raga.bysani (8/29/2013)

---

Thank for reply ,

We are moving record by record using for each loop container

But will this work without the package being failed , when ever there is...

I don't think that is possible.

Rows are moved in batches, and it's an all or nothing transaction.

If you want to implement something like this, you'll need to do the clean-up...

It's a free download, so I guess there's no license fee.

Rollback how? If a row is sent to an error output, it is not written to the destination.

And how can you improve a query? By updating statistics, minimize logging,...

BIDS (now SSDT) is for developing BI solutions. You need SQL Server Data Tools (SSDT). Yes, I know they have the same name now 😀

The SSDT for database projects is...

Some of the things I'd check:

* are statistics updated?

* is the table indexed? Are they indexed well?

* Are there unnecessary indexes?

* compression

* partitioning

If the sequence is b, B, b., ... and you select data starting from B, the b is dropped.

Interesting question by...