If you have the disk space and the server resources available, you might want to try replicating the queried tables from one server to the other. That way the query...

Try creating multiple publications. We segregated our replication (transactional not merge, but that shouldn't make any difference) into multiple publications to make our snapshots easier to manage.

Our largest tables each...

Also:

Watch out for security contexts if your jobs directly access a server's file system or other resources external to SQL Server. BCP commands, etc.

Bill Bertovich

bbertovich@eliberation.com

Assuming the denormalized columns are exclusive (which seems to be the case based upon the table schema) use the UNION ALL command. The UNION command alone will cause a lot...

It sounds like a high volume OLTP environment. The typical challenge with this type of environment is keeping the indexes optimized and dealing with the contention of all those inserts...

As Allen stated earlier, look at the query plan and the general well being of the indexes on the tables. Correct indexes? Need to be defragged/rebuilt? Update statistics?

We had a...

For those who may be interested, there are a couple of awesome security tools from NGS Software, one of which would have identified the breach discussed in this forum: Typhoon...

Notes from the field:

We use bit-wise comparisons througout our entire database, not only for question and answer structures, but for all flags. It has worked well for us in a...

Alex,

In the SQL Server diagram, right click on the relationship. Uncheck the three boxes pertaining to enforcement of relationships. The relationships will not be enforced during normal processing, but...

Hey David, More detail:

You were on target, but we don't process nightly batches. Instead, we alternate between two small servers. When one is processing the other is capturing, and...

Hi Andy, There is one case where we've made notable improvements in performance by removing the primary key - high volume transaction buckets.

I work for a profitable dotcom, imagine that!...