markganley (10/7/2010)

---

The PLE was giving at least a value all the time we were running the server prior to stopping it and setting up mirroring. Nothing else has changed on...

kennywashington2000 (10/6/2010)

---

Thanks for the reply, I was not aware that I was supposed to insert anything into the field since it is a reference to a Primary key field that...

As far as I can see script is inserting nothing in employee50.Job_Title_ID therefore is correct to show there... nothing.

Also, I would define employee50.Job_Title_ID as Not Null.

Always use the...

amit-1143912 (10/6/2010)

---

...I cannot recreate this table. Clustered index not to be created on this table.

how can I apply the partiton scheme to the existing table or a exisiting table with...

jeboesch (10/6/2010)

---

Thanks, this gives me the desired output but I received the following error message:

Invalid length parameter passed to the SUBSTRING function.

The email field contains some NULL values, could that...

jerry-621596 (10/6/2010)

---

I have a table with nearly 6,000 rows that needs to be updated with new rows periodically. The update is based on whether the email address already exists....

I'm sorry, my bad. I missunderstood - it happens to me 🙂

saurabh.deshpande (10/6/2010)

---

I am not into Database...

Jake50515 (9/24/2010)

---

I have a database that is losing performance very quickly when the db size grows large. If I run my insertion benchmark on a clean database, I can...

Employee73.Job_Title_ID FK references Job_Titles_8 PK

Script shows creation of Job_Titles_10 but doesn't show creation of Job_Titles_8

Script shows neither Job_Titles_8 nor Job_Titles_10 population.

Can't troubleshoot without proper information 🙂

I vote for Michael's solution.

No reason not to handle it at "pool" level - I would probably rename it as "investor entity" so to differentiate from "investor individual".

Most probably I'll...

Being both a SQL Server DBA and an Oracle OCP you should know what the differences are, don't you? 😉

This might be a valid alternative but there are others. That's why I...

saurabh.deshpande (10/6/2010)

---

Actually, I am intracting with mulpital RDBMS during my assigments.

So, I thought of building Competency within mulpital database systems.

So, you can say...

saurabh.deshpande (10/6/2010)

---

Can we keep this post open, so that everyone can write, the differences they found while working on these two platforms. Or you can more in...