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
How to start and end transact-sql statements?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is inner join in sql server joins?
What is delete query?
What is normalization? What number of normalization shapes are there?
What is a field in a table?
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
How are SQL Server databases physically stored under Windows 2000?
What is the difference between OLEDB and ODBC
What stored by the master?
What is the purpose of UPDATE STATISTICS?
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?