SQL Server Performance

Filtering the data (Dynamic Filtering)

Discussion in 'Performance Tuning for SQL Server Replication' started by santnair, Sep 8, 2005.

  1. santnair New Member


    Here I need Dynamic Filtering. As we are using merge replication, we have to go for Dynamic filtering over Transforming published data, correct me if i am wrong.

    How to do the Dynamic filtering? Do I have to create user defined function or will manage with system functions.

  2. ghemant Moderator

    Hi,<br />don't know how much it helps :<br /><br /><a href='msdn.microsoft.com/library/ en-us/whatsnew/wn_whatnew_3cdv.asp' target='_blank' title='msdn.microsoft.com/library/ en-us/whatsnew/wn_whatnew_3cdv.asp'>msdn.microsoft.com/library/ en-us/whatsnew/wn_whatnew_3cdv.asp</a><br /><br /><a href='www.certmag.com/bookshelf/Sharma.CH07.qxd.pdf' target='_blank' title='www.certmag.com/bookshelf/Sharma.CH07.qxd.pdf'>www.certmag.com/bookshelf/Sharma.CH07.qxd.pdf </a> <br /><br /><a href='www.microsoft.com/technet/prodtechnol/ sql/2000/reskit/part1/c0261.mspx' target='_blank' title='www.microsoft.com/technet/prodtechnol/ sql/2000/reskit/part1/c0261.mspx'>www.microsoft.com/technet/prodtechnol/ sql/2000/reskit/part1/c0261.mspx </a> <br /><br /><br />HTH<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  3. dineshasanka Moderator

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_9b5a.asp is havning ht enesseary information

  4. santnair New Member


    Is there any step-by-strep in creating , dynamic snapshots,dynamic filtering.

    thanks in advance.

  5. satya Moderator

Share This Page