Viewing 15 posts - 1,981 through 1,995 (of 3,669 total)
Just curious - have you looking into replicating stored procedure execution to cut down on the transaction volume?
Absolutely, I was intending to write up an article on it. It...
March 31, 2010 at 2:29 pm
Paul White NZ (3/31/2010)
Assuming the box is licenced per-processor, would you expect any advantage to running the separate distribution databases in separate instances?
I'm not up to date with licensing requirements...
March 31, 2010 at 11:00 am
Varies from
Physical 8CPU 64bit W2K8 SQL2008 standard edition with 12GB RAM to
Virtual 4CPU 32bit W2K3 SQL2005 Standard edition with 8 GB RAM.
Mainly push subscriptions but pull used for...
March 31, 2010 at 5:53 am
No offence taken.
We have four production distributors two of which are virtual servers.
We put roughly 24 billion transactions through them each day. We have spiked up to 370 billion...
March 31, 2010 at 1:33 am
If you have everything hammering through one database you are talking about one transaction table having to deal with all transactions. Ditto the commands table.
Try reindexing a very large...
March 30, 2010 at 2:15 pm
On one particular publication we changed the retention period to 3 hours because if something goes wrong with the subscriber then the transactions start building up in the distributor and...
March 30, 2010 at 10:18 am
It is very hard to say what "a certain size" is because it depends on the hardware and configuration of the machine that is acting as a distributor and also...
March 30, 2010 at 6:53 am
And I thought I was hard done by because a 1.5 million record update took 15 seconds!
March 18, 2010 at 2:35 pm
Thinking about Henry Ford's quote reminded me of the last model Ford Escort. Ford asked its customers what they wanted and out came something that showed the world that...
March 18, 2010 at 2:16 pm
Thanks,
The IBM list gave a good jump start. It's just a shame that there isn't an inbuilt function that returns a table of these words.
It would be great to...
March 18, 2010 at 5:52 am
If you denormalise the database where data it maintained you add to the cost of data maintenance tasks and you run the increased risk of being hit by bugs due...
March 15, 2010 at 2:54 am
I've done quite a bit of testing of NEWID() and randomness and it is a very effective random number generator.
As the GUID comprises of blocks of hexadecimal these blocks can...
March 1, 2010 at 2:04 am
As with all things DBA related it depends.
If you have a very large product set then adding in an extra column for the Top 'n' products wastes storage though in...
February 15, 2010 at 11:32 am
Jeff, there is a short and illuminating article on http://www.infoq.com http://www.infoq.com/vendorcontent/show.action?vcr=847 regarding technical debt in agile projects that echoes what you say.
Basically a project team is given a fixed immutable...
February 11, 2010 at 1:40 am
Perhaps someone could confirm this for me but on the subject of right-sizing datatypes I gather that shrinking fixed length datatypes after creation makes a metadata change but not a...
February 10, 2010 at 3:22 pm
Viewing 15 posts - 1,981 through 1,995 (of 3,669 total)