Can you explain about buffer cash and log cache in sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Why I am getting this error when renaming a database in ms sql server?

0 Answers  


What are the types of subquery?

0 Answers  


What is read committed?

0 Answers  


How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  


What is raid, and how it can influence database performance?

0 Answers  






how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


Explain full-text query in sql server?

0 Answers  


What are the advantages to use stored procedures?

0 Answers   Ernst Young,


How to link tables in sql server?

0 Answers  


What is openrowset sql server?

0 Answers  


1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  


Categories