Thank you guys!

Your suggestions helped me

Regards

IgorMi

anthony.green (11/20/2012)

---

IgorMi (11/20/2012)

---

Except the collation, your...

Except the collation, your code does...

Hi,

You could use MERGE statement in this case, but you have to create indexes on the joining columns. The following link can help you: http://technet.microsoft.com/en-us/library/cc879317.aspx

Regards

IgorMi

Sean Lange (11/19/2012)

---

Where did you hear this? There is nothing...

sqlnaive (11/19/2012)

---

We have a procedure which performs _NO_ update or delete operation but only read. This procedure runs daily without any issue and gets completed within 1-2 minutes but one...

haiao2000 (11/19/2012)

---

I just thought of a solution after posting:

--dump existing data from target table into a temp table

select * INTO #TempTable from TargetTable;

--drop the TargetTable

drop targetTable;

--recreate TargetTable with additional fields...

Hi,

Your code gives me an error:

Msg 468, Level 16, State 9, Line 8

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Use this simple code:

select db_name(database_id)...

George M Parker (11/14/2012)

---

The difference is the "NOT NULL" constraint between the two statements.

The following statement converts the column to a nullable column (I ran it in a test scenario...

No it is not. It is a varchar column only.

Yeah, I always appreciate more experienced members answers, especially Gail's

Thanks

IgorMi

Hi All,

My answer was just one sentence, having in mind that I just started a migration process. So it matters what kind of migration you have. For example the above...

Hi Jeff,

Simply brilliant!

Thanks

IgorMi

computergirl (10/16/2012)

---

Okay I am kind of new to this and I am trying to create a table and if the user doesn't fill all the fields I need the empty...

Hi,

You may have space issues for your tempdb, or generally space issues, and then it is slow.

Are you rebuilding online or offline?

Regards

IgorMi