Sql server
- Can you explain about buffer cash and log Cache in sql
server? - March 31, 2010 at 19:10 PM by Vidya Sagar
Can you explain about buffer cash and log Cache in sql
server?
Buffer Cache: Buffer
cache is a memory pool in which data pages are read. It performance of the
buffer cache is indicated as follows: 95% indicates that pages that were found
in the memory are 95% of time. Another 5% is needed for physical disk access.
If the value falls below 90%, it is the indication of more physical memory
requirement on the server.
Log Caches: Log
cache is a memory pool used to read and write the log pages. A set of cache
pages are available in each log cache. The synchronization is reduced between
log and data buffers by managing log caches separately from the buffer cache.
Overview of integration of CLR with SQL Server, Advantages of CLR
integration............
What is XQuery language?
Explain the syntax rule of XQuery language.
XQuery expression contains two parts: the Prolog and the Body. Explain them
Explain PATH expression in XQuery with an example................
What are the major improvements in SQL Server 2005 for XML supports?
What is XQuery? Discuss about XQuery structure.
Explain the concepts and capabilities of FOR XML in SQL Server 2005.
Explain the purpose of PATH mode of FOR XML in SQL Server 2005 with an
example..............
Microsoft SQL server is a relational database management system. It uses MS- SQL
as the query language. SQL Server offers a high level of security, reliability
and scalability depending on the business needs...............
|
