Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sachin patil
DBMS : Client Side processing
File Level Locking
Network traffic is High
Distributed Network not Supported
Nomenclature
Concept of File
RDBMS : Server Side Processing
Row Level Locking
Network traffic is Low
Distributed Network Supported
Nomenclature
Concept of Table
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What are synonyms?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to declare and use cursor variables?
Can group functions be mixed with non-group selection fields in ms sql server?
How to assign new column names in a view?
can you implement data mining in SSRS?
What is raid, and how it can influence database performance?
What are cursors stored procedures and triggers?
Explain external key management in sql server 2008
What are the advantages of using cte?
What are the 7 disadvantages to a manual system?
What is user-defined inline table-valued function?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What are the tools available in market as an alternative to sql server reporting services?
