Google is your friend:

http://www.sqlteam.com/article/sql-server-indexes-the-basics

Here is another from Brent Ozar:

http://www.brentozar.com/archive/2006/04/sql-server-training-for-developers-primary-keys-indexes/[/url]

Edwin, you just create a normal view with the name of the source table :

CREATE...

by capturing statement completed you maybe able to tell what is being executed.

Is coming from Hibernate. You should be able to use some cheaper setting on the Test Connection Query as well as the way in which 3cp0 handles...

Here is some info about verifying/correcting the number of Virtual Log Files:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Yup this is MySQL Code you are posting in the wrong forums!!!

Edwin (5/4/2009)

---

Hello rooms,

I divieded the original table on my transaction replication into two index views.

Original Table: T

able TestTable

PK1,PK2, PK3, PK4, col1, col2, col3,col4.

CREATE VIEW idxview1 WITH...

Here is an example:

CREATE TRIGGER [TR_Yourtablename_instead_of_iud] ON [Yourtablename]

INSTEAD OF INSERT,UPDATE,DELETE...

Great debate. My vote goes for 13 separated databases!

In addition the composition of the files and the DDL for the tables is needed.

I personally use instead-of triggers marked as NFR. It has worked very well for me.

If you don't allow deletes and somehow you are running updates on Primary Keys or unique indexes columns, these get replicated as a Delete+Insert. Because the deletes were not sent...

This usually happens due to resource contention on the server. Verify if you have a very high number of locks in distribution DB.

Also ensure that the timeout values for...

Loops are not always "evil". The time spent backing up the DB is orderS of magnitude higher than the little looping time to get next DB name.

Now, for querying data...

you should add "statement:completed" to see the text in the trace.