Viewing 11 posts - 1 through 11 (of 11 total)
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...
July 29, 2003 at 2:18 pm
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...
July 25, 2003 at 4:33 pm
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
July 25, 2003 at 3:41 pm
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...
July 25, 2003 at 3:18 pm
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...
June 6, 2003 at 12:56 pm
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...
June 6, 2003 at 10:23 am
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...
February 21, 2003 at 10:58 am
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...
January 20, 2003 at 11:41 am
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...
July 22, 2002 at 11:46 am
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...
March 28, 2002 at 7:03 pm
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!...
March 25, 2002 at 11:07 am
Viewing 11 posts - 1 through 11 (of 11 total)