March 2007 - Posts

• SQL Full-text search anomolies

  On the newsgropes recently I have encountered some posters who are perplexed by the results of their full-text searches. The first poster was puzzled as to why searches on f.b.i. would not find F.B.I. in his content. SQL FTS and Microsoft Search products Read More... Posted Thursday, March 08, 2007 2:11 PM by Hilary Cotter | 1 Comments

• handy replication proc

  A friend of mine called me up last night. He had a problem replicating 300,000,000 transactions per day, or was it per hour. Can't recall, it was a late night. Anyhowze, with volumes like this replication might not be the best tool. His problem was that Read More... Posted Thursday, March 01, 2007 4:52 PM by Hilary Cotter | 0 Comments

• transaction marks

  There seems to be some confusion out there in the internet about how to implement transaction marks. Or perhaps I was merely very confused about how to implement them. Transaction marks allow you to restore two or more database to a consistent point in Read More... Posted Thursday, March 01, 2007 4:46 PM by Hilary Cotter | 0 Comments