Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?


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

Post New Answer

More SQL Server Interview Questions

How to start and end transact-sql statements?

0 Answers  


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  


What is inner join in sql server joins?

0 Answers  


What is delete query?

0 Answers  


What is normalization? What number of normalization shapes are there?

0 Answers  






What is a field in a table?

0 Answers  


1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,


How are SQL Server databases physically stored under Windows 2000?

1 Answers  


What is the difference between OLEDB and ODBC

4 Answers   CFCI,


What stored by the master?

0 Answers  


What is the purpose of UPDATE STATISTICS?

2 Answers  


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  


Categories