Kit G (7/6/2011)

---

GilaMonster (7/6/2011)

---

Branching, cause 2 bad jokes are worse than one.

Kit G (7/6/2011)

---

Fal (7/6/2011)

---

Please, kind...

Do everything you need to do where you find "insert code here". You can handle everything with a single transaction and rollback the whole work if something goes wrong.

At least,...

Then you can safely use my template.

I usually work with this template:

CREATE PROCEDURE <ProcedureName, sysname, >

AS

BEGIN

SET NOCOUNT ON

DECLARE @localTran bit

IF...

Hmmm... doesn't look like T-SQL code for SQL Server.

Are you sure?

You must be working for a GREAT company, Johan.

I tried to figure out how that conversation would have been here at my shop. I...

In order to have different timestamps on every row, you would have to change the batchsize to "1", but it would end up slowing down everything and I'm not sure...

I'm afraid there's not much you can do.

However, I would save previous versions of the package to a source control system, rather than relying on SQL Server versioning.

The only...

... and timely comes a blog post from Gail[/url]!

Well done, Remi.

Ninja's_RGR'us (7/5/2011)

---

Also AFAIK a loop join is NOT the best option with that many rows. IIRC HASH join is (67% sure)... don't feel like re-reading Grant's book on the...

Ninja's_RGR'us (7/5/2011)

---

Gianluca Sartori (7/5/2011)

---

Looks like an estimated plan...

However 4 MLN rows from both tables is a huge load. I suspect it would run much better with a loop join. Can...

Looks like an estimated plan...

However 4 MLN rows from both tables is a huge load. I suspect it would run much better with a loop join. Can you force it...

You could say that it is universally known as a bad practice since 1970 and it is very sad and frustrating that somebody still think to know better than Mr.Codd,...

...sorry, I could not resist.

You can check the setup logs in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LogYou should find a line similar to this:

Property(S): LogonUser = JohnDoe

Hope this helps

Gianluca

I happened to install some. 😛

I guess this is not the answer you were looking for...