For a 7.5 million rows I do not see the need of doing it in batches... you just have to insert...

You find Entities at ER modeling time - when you identify the entities and relationships of your...

For starters, I think that this is a very interesting idea and I'm looking forward to what other people has to say about it.

On the other hand I do think...

Assuming you figure out a way to join those tables,...

I'm assuming the target database is Oracle and that the datatype of mytable.date is DATE.

If this is the case you have two options, option #1 is to write a stored...

jarid.lawson (1/6/2012)

---

Thanks for the reassurance. I'm designing a new financial tracking system as the company's new DBA...and I'm trying to do this as perfect as I can from the start....

Nope, you are not.

As far as I understand the scenario there is a many-to-many relationship between Clients and Products - the bridge table breaks that...

duplicate entry

Please do not cross post - that fragments responses and duplicates effort.

Original post is here... http://www.sqlservercentral.com/Forums/Topic1231569-1292-1.aspx#bm1231582

Wait until it works 😀 Glad to help.

Yes. I think so.

I think something like this will...

I would query msdb..backupset table.

acrutchley (1/6/2012)

---

I have been responsible for administrating my companies sql databases for a number of years now, however I have never actually built my own database from scratch and I...

Well... you designed it, don't you?

Each row on the particular FACT table is supposed to describe a factual event on your OLTP...

Brandie Tarvin (1/6/2012)

---

It's more than just the quotations. NUMBER is an invalid...