ah.... Insert. (Hits self with palm to head) Thank you guys. I'm going to give that a try. Thats super helpful.

bump

Also I hate to ask a stupid question but if a database is using the full recovery model isnt it then transactional?

If it isn't then what determines if a database...

MysteryJimbo (5/18/2011)

---

Can't tell by that that example as it is a select. Generally you can tell by the table structures and relationships or you will have to ask the...

MysteryJimbo (5/18/2011)

---

So long as the table contains a primary it doesnt matter.

A snapshot is only required to initialise a subscriber. After this you will only need to generate small...

Suresh B. (5/17/2011)

---

Additional server hardware is not necessary. You can use Publisher as the Distributor (if it can bear the load).

No logins are replicated. You have to create them yourself.

Few...

Stefan,

I am going to give this a go keeping in mind all the points you brought up. If you have some time can you look at the code I...

Stefan Krzywicki (4/7/2011)

---

Stefan Krzywicki (4/6/2011)

---

Have you already looked at the indexes you have on the table?

If you primarily query by document_no, then you might want to partition by...

Stefan Krzywicki (4/7/2011)[hr

I really think the best way for you to improve performance on this table is to learn more about indexes and primary keys and improve the ones you...

Stefan Krzywicki (4/6/2011)

---

Have you already looked at the indexes you have on the table? That's where I'd start if I were trying to address performance problems.

It depends on how you're...

Jeff Moden (4/7/2011)

---

First, no, it would not need to be a part of the front end. It could be setup to default to whatever the current date...

Jeff,

What would be the best way to do that though?

We already have millions of records. Also would it need to be part of the front end application?

Thanks to both of your for the feedback. I'll give that document a read through today. I think I'll be able to use the document no_ column I described. Its...

Andy,

Great article and I am looking forward to the rest of the series. I am just starting to learn SSIS as my company is looking for faster ways to...

nivek-224024 (3/29/2011)

---

I would recommend you take a look at some of the information_schema...