Using a configuration?

paul.knibbs (3/7/2014)

---

Actually, a single disk...

The quick and dirty way to find...

I'd take this as a two phase approach.

First, you need to get your current data into the format you want. No matter what you do, you're going to do...

Cafescott,

I think you have multiple issues here that while you need to address them simultaneously, need to be approached independently.

The first is the physical security and access, which has already...

free_mascot (3/5/2014)

---

Bulk and Simple use similar logging techniques for minimally logged transactions, so either would work for that purpose. In my experience, while this will help, it requires a...

GilaMonster (3/5/2014)

---

Evil Kraig F (3/5/2014)

---

GilaMonster (3/5/2014)

---

I would create, as an index for that query:

create index IX_A_Col1 on A ( Col1, IndexID )

Having it as a second key column is more...

GilaMonster (3/5/2014)

---

I would create, as an index for that query:

create index IX_A_Col1 on A ( Col1, IndexID )

Having it as a second key column is more useful than having it...

No, the clustered index is already included in all nonclustered indexes. The include would be superfluous unless you're trying to protect against someone changing the clustered index in the...

N_Muller (3/5/2014)

---

Would there be any benefit to include columns that are part of the primary key on a non-clustered index, even if I don't intend to add it to the...

george sibbald (3/5/2014)

---

yes, but the question says insert, rather than import, so does SSIS run the insert as a bulk import by default, or is that a setting you can...

Just double checking. :)...

Hrm, if...

Hey Barry, welcome back.

In general, not much... Other than I apparently created a 3! point question for the QotD... 😎

(I didn't think it was THAT difficult...)

Nope, but understand, when you say Raid 0, that's not a single disk.

Raid 0 is a multidisk stripe that if any fail you lose the stripe. Single disk =...