Tag Info

New answers tagged

0

If you've read through the answers posted above, you already know why NO SQL is much hyped. In simpler terms I can say it's being used because of the following reasons: If your data is very very huge (in terms of PETABYTES, TERABYTES etc.) If this huge data is very loosly coupled and there is no need for relational algebra. (i.e., information is very ...


1

All things being equal, it is logical to assume that better hardware = better performance. However, computers are strange beasts - I know that with Oracle, if you assign very large sizes (you need good hardware) to certain caches, you can actually slow down the machine. The only real suggestion that I have is that you test, test and test again. You cannot ...


0

You may need to elaborate on this a bit more but yes it is possible to store that data as you've described it. Here's an example, using your document model, of such an array of dates in a document in a collection. Personally, I would look at modifying this as I've described at the end but of course it all depends on what your queries need to do with the ...


0

There are multiple reasons for a query to run slowly. May be because of your engine that is not fine tuned, but suppose your engine is well tuned. Begin by printing to a file the query plan of your sql query. Copy the query and open DBACCESS. Run "set explain on" and paste your query and execute it in the "Query language " of DBACCESS utility. Check the ...


2

SQL Server has Change Data Capture in it's Enterprise edition. From msdn link to information: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Column information and the metadata that is required to apply ...



Top 50 recent answers are included