Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jon3k
Starting Member
49 Posts |
 Posted - 2003-12-26 : 17:29:43
|
| Just curious what that means. I was reading up on it at msdn, and I came across this:"Options available with merge replication include filtering published data horizontally and vertically, including join filters and dynamic filters, using alternate synchronization partners, optimizing synchronization to improve merge performance, validating replicated data to ensure synchronization, and using attachable subscription databases. "What does it mean to apply vertically or horizontally? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-29 : 11:59:33
|
As it implies... myTable99 | ____________|______________ |Col1 Col2 | Col3 Col4| |A B | C D | |E F | G H | Horizontal---------------------|---------------------------------- |I J | K L | Horizontal |M N | O P | -------------|--------------- | Verical|Vertical Warehousing employs these thing more for speed in an OLAP environment....haven't played with it much....but you can create your own warehouse "structures" with out doing this....All of this is can be done with views..CREATE VIEW myView99 AS SELECT Col1, Col2, Col3, Col4FROM myTable99a INNER JOIN on myTable99b ON a.key = b.keyTable a would be either 2 columns or only loaded with a range of values and contain all 4 columns (This could be a partitioned, and may be updateable...acutall the syntax would be a UNION).I don't the first one is updateable....But if you need to do olap, it'd be more likely be loads to predefined objects...All kinds of MOO today..Brett8-) |
 |
|
|
|
|
|
Replication Filtering: Horizontal and Vertical?