mpradeesh (10/14/2010)

---

Here is my situation for Designing a Data Warehouse Star Schema

For each transactional (Fact) data the , account(dimension , but a fact table as it may change...

You made my day 😀

Please do not take this the wrong way but you shouldn't be doing data modeling if you do not know what Referential...

Not only in the SQL Server market - same happens with other RDBMS technologies.

Some DBA crown themselves "Senior" just because...

My tool of choice is ERWin.

Check here for details http://www.ca.com/files/productbriefs/erwin_data_modeler_product_brief.pdf

:blink: please do elaborate.

Still amazes me - yet it doesn't surprise me anymore - how this "surrogate Vs natural key debate" goes on and on.

Please let me start by stating my position on...

Lynn Pettis (10/13/2010)

---

In my opinion, both Oracle and SQL Server have their place. What I have seen, however, is that the decision to use one over the other is...

Always remember SQL Server carries Sybase genes; don't look at SQL Server 4.0 as SQL Server date of birth...

Let me point to just two differences that some people may construct as Oracle advantages.

Oracle runs on multiple O/S

SQL Server runs only on...

Do you have a ticketing system to track changes?

Is there an established weekly Change Management call scheduled?

bassam86 (10/13/2010)

---

Suppose I have two entity X and Y that have the same definition

What is the best database design,Is to create tow tables one for x and other to...

André Lozeau (10/13/2010)

---

We have a 600 Gb Siebel 7.7 database that runs on SQL-Server 2000, of which one table uses 320 Gb for 140 millions rows. We are in the...

MarvinTheAndriod (10/11/2010)

---

In the case of a disaster recovery we currently use the following script, (http://support.microsoft.com/kb/918992/) to transfer logins across from our live server to our backup server. The server is...

kanika.bhagat (10/10/2010)

---

I have one table student and three fields mtt1,mtt2 and sum.I want to update sum field whenever there is a new value inserted in mtt1 and mtt2.I want to...