Tag Info

New answers tagged

0

There is no a definitive answer. Anyway I suggest, if possible, to store tempdb files in different LUN. But it is worth only if tempdb is under pressure. In my environment I use shared storage also for tempdb for performance reasons: my local disks are slower then shared storage via EMC.


3

Source control. This way you have a centralized store for all of your scripts so that any DBA/Developer can access them and use them if needed. Tracking changes to core scripts used day to day in your environment is critical. You could convert them to stored procedures so that they are included in the database backup it's self but this doesn't provide an ...


2

Use a Sequence. A sequence is a database-wide generator of unique integers that can provide unique surrogate keys.


2

Since there is already and answer submitted, and a useful and valid one at that, I do not want to distract from it's own usefulness but there are indeed points to raise that go way beyond just a short comment. So consider this "augmentation", which is hopefully valid but primarily in addition to what has already been said. The truth is to really consider ...


2

Since best practice also suggest that "The appropriate number of mongos processes will depend on the nature of the application and deployment" I started to wonder whether our usage of mongos actually appropriate I think this is a question that ultimately only you can answer, as the documentation refers to. One of the recommended strategies is to ...


0

The design of your tables is not, as you noted, an OOP inheritance. The underlying model is simpler: Do not duplicate your data! The more data you have, the more important this is because: Nobody will type the duplicate data exactly the same in all cases. (Names, Addresses, etc.) If you have entered similar data in two different tables, you will ...


2

The privilege on DATABASE only grants general connection rights to the database and no more. A user with just that privilege can only see what the general public is allowed to see. To grant read access to all tables, you also need privileges on all schemas and tables: GRANT USAGE ON SCHEMA public TO myuser; -- more schemas? GRANT SELECT ON ALL TABLES IN ...



Top 50 recent answers are included