The Record That Never Existed (as a committed row)

Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]

Hash Match

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.

RE: VBA or ADO forum

There are a lot of user forums you could use. I find www.CodeGuru.com one of the better ones. But what is the issue you are having and maybe someone here will offer help.

RE: RSS Newsfeeds to SQL?

Take a look here, this might help.http://home.att.net/~codeLibrary/XML/rss.htm

Subscription validation

Hi!I have a table with a field of image type.  Trying to validate it: validate subscriptions -> validation options, then combine all possible options variations.  Get a netsend message that subscribers pass data validation.  At the same time I have one (or more) records with empty image field on all subscribers, that is filled on […]