CirquedeSQLeil (4/5/2010)

---

This is a good method to quickly find stop gaps in your knowledge. Performing interviews can be a drain if you are expecting a lot of success. ...

chris.stuart (4/3/2009)

---

4) I would also like to set the logging db to maybe just a few gigs with the space being reused and records being committed as and when needed,...

During INSERT, the more indexes you have on target table the more overhead you are adding to the process a.k.a....

Sasidhar is correct.

FKs are there to enforce referential integrity rules. No referential integrity rules takes into consideration one child row with two alternative parents.

If this is a business spec it...

As pointed by Jason an Oracle person wrote the question.

In the Oracle world a explicit cursor is a cursor you define in the "declare" section - this is pl/sql stuff...

Standard Edition is expected to support Import/Export - I would open a ticket with Microsoft.

it didn't work as expected, huh? 😀

Answering your question it all depends...

I do not see any need for table partitioning... a 500 pages book with 25 sentences per page will be stored in 12,500 rows - ten thousand books will be...

One datamart per FACTual table, no FACTual table duplicates.

Sure!

Look at the link I posted, customize the code so to write your own function and you...

Do you mean... by clicking here and there? don't think so.

You can always convert data already...

Mostly everything is possible, check this http://www.codeguru.com/columns/dotnettips/article.php/c7529/ 😉

Just bing "Replication - PBworks: PBworks Online Collaboration" ... first return on the...

You can start with BOL - comes with SQL Server for free.

On the other hand, if you do not have database background may be a good idea to read some...

ask your DBA to run query as either "sa" or "dbo" on target database.