Glad to help.

It can be done, full process is described here http://www.sandhill.co.uk/erwin/ERwinIndexNameRule.asp?dm_i=6J9,CSSW,RPMQO,10I86,1

gyoung 93471 (3/21/2012)

---

Given that I don't see significant database operations on buildings and floors, I wouldn't isolate them.

Therefore, two tables work nicely and cleanly.

1) create a table for rooms (room_id,...

Yes you can... check here http://erwin.com/uploads/tips_techniques/Using_Naming_Standards.pdf

winston Smith (3/21/2012)

---

Technically you can normalize the crap out of any entity model. this means adding more tables, primary/foreign key links etc.

And although you will have a very well normalized...

Two questions:

1- How big is your SQL Server database?

2- Do you need near-real-time extracts to DB2 or a daily snapshot would suffice?

Depending on answers I would consider either restoring a...

Okay... for starters, please show us how you do...

shanish (3/19/2012)

---

Hi everybody, I have a doubt here,

I have a table contains the columns StudentId,SubjectId,ComponentId,Marks,PartNo

I have a record for a student,

1,1,1,40,1 // here he scored 40 in part...

weston_086 (3/17/2012)

---

so then can i insert max value of that column instead of default -1 in place of null values.bcz my manager does want null values in foreign key...

Anamika (3/15/2012)

---

that can be done in a stored procedure. but how about doing the same in SSIS?

i expect this to be done using for each loop and inside that...

dgossdba (3/15/2012)

---

Correct, I have read that it is a problem with the Microsoft OLEDB version of the driver. However, I'm using the Oracle Client version of the provider on...

One solution would be to load: Database_name, Table_name and Column_name into a cursor then loop the cursor and process each table as needed.

If SAP is running on SS2K8 then you may be able to rely on the SS2K8 native CDC feature.

dgossdba (3/14/2012)

---

Yes,

We can see what query is passed to the server when looking at the session that is created by MSSQL. If we run the query with the 4...

Finally! I knew quantum mechanics would sooner or later apply to our trade 😀

Not necessarily. It all depends on having a proper indexing...