Do you select the exact same amount of rows every time?

Do you have some sort of mechanism that detects if rows are updates or inserts?

Sure. If they're just sandboxes to play with, SQL Server 2012 will have all the features you already use in SQL Server 2008 + exciting new features in the TSQL...

cfradenburg (6/21/2012)

---

I'm assuming SQL Agent on Dev2 is what's running the package. Take a look at the error log on Dev1. You'll likely see some login errors for...

mamatha17.r (6/21/2012)

---

I have one source table distributing data into two dest tables using incremental load concept but i need to insert new records if record already exists i wont...

Another traditional way is doing it in SSIS: OLE DB Destination with Fast Load for the inserts and OLE DB Command (ugh) for the updates.

This was slow because the updates...

Very interesting question. I never use this syntax with the correlated subquery, so it would have been nice to give a bit more explanation on that.

Pretty easy if you had to attach the AdventureWorks MDF files multiple times 😀

Oh god not him.

He's the most important reason I have such a high post count. Trying to help him usually results...

ard5karthick (6/21/2012)

---

Hi,

We have created another connection manager which will have the server details of the Configuration table.

The Configuration Table is placed in msdb system database and SQL Server authentication is...

Debbie Edwards (6/21/2012)

---

I have 2 threads open on this...

Stefan Krzywicki (6/20/2012)

---

Koen Verbeeck (6/19/2012)

---

I never...

For me, a kilobyte is still 1000 bytes. kilo = 1000

Michael G (6/20/2012)

---

Would that be 511 PB or 524 PB?

Googling...

1 PB = 1000000000000000B = 10005 B = 1015 B = 1 million gigabytes = 1 thousand terabytes

So if the correct...

The sheet names are still the same?

JJ-469859 (6/19/2012)

---

Wow thanks for the thorough replies and links! The only question is that in the link provided (http://www.jamesserra.com/archive/2012/04/sql-server-2012-multidimensional-vs-tabular/) it says that Tabular uses the existing data model and does...