Yeh, tried this, very difficult to do though with busy databases. I will try a few ideas out and see what happens.

Hey Andy, what will people win for reviewing one of my articles?? ;))

Some interesting points throughout the article. I run a range of sites where we utilise 3 db...

Hi Steven

Select properties of your DB and go to the last tab called "permissions".

Cheers

Ck

Hi Steven

Select properties of your DB and go to the last tab called "permissions".

Cheers

Ck

hmm.. looks like its a XP problem, works perfectly under win2k as running EE of sqlserver. I will try patching up my installation at home and see what happens...

far out, forgot all about that one! sheesh

thanks steve

Hi

I would test this very carefully, from memory here I had a senario some time back where the trigger continued to fire. I will have to re-test.

Cheers

Ck

Hi

I have 4gb ram on my box, and have pinned 290Mb data (37 tables of 300 in the schema and 800,000 rows)... watch your buffer cache for variences with hit...

sqlnet setup properly on the server? and if its working via sqlplus to the oracle box then you shouldnt have a problem, the problem may be simply with your config...

steve, all the internals and other issues related to the DBMS engine and what makes it tick.

Hi

hmm.. this is a strange one. From all the restores ive done over the years (v7/ss2k) the recovery model is restored "as is" based on the properties setting at...

All that said though, fragmentatiobn will still occur in 64kb chunks? therfore fragmentation will never be zero in well used (many concurrent users and transaction) objects. Surely sql 2k server...

Hi

This will not resolve your problem, to me it sounds like a fundamental application architecture problem and the vendor is talking garbage, id be very supprised to see any difference...

Hi all

I dont entirely agree with Antares686 in regard to the fragmentation issue. First of all, you cant a avoid physical fragmentation of the database files, there is no...

I agree with codedoc, versioning can make a simple data model very complex, especialy for end-users quering it (well, its not that bad with some views but someone has to...