![]() If you don’t need log then have the recovery model simple instead of full. You have to make sure whether you need log or not. Read article to surprise interviewer with your answer. SQL server doesn’t allow you to truncate the log now otherwise whole purpose of a DB is defeated. Somewhere you may also need to use TABLOCKX when you want an exclusive lock on the table in the query.Īnswer 3: BACKUP LOG TestDB WITH TRUNCATE_ONLY is gone. This is a nice way to avoid the wastage of sql server DB engine processing for lock escalation. Understand that whole table would be locked for the processing thenn this is better to use TABLOCK hint and get complete table blocked. SELECT * FROM master.sysprocesses where blocked 0ĭeadlock: When something happens as follows: Error 1205 is reported by SQL Server for deadlock.Īnswer 2: When the DB engine would try to lock page first and then it escalates locks to page and then table. SELECT * FROM sys.dm_exec_requests where blocked 0 Lock: DB engine locks the rows/page/table to access the data which is worked upon according to the query.īlock: When one process blocks the resources of another process then blocking happens. ![]() How to view the error log for any specific instance? Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?ġ0. When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.ĩ. What are the ways to find what code is running for any spid?Ĩ. Where does the copy job runs in the logshipping… Primary or secondary?ħ. What changes in the front end code is needed if mirroring is implemented for the high availability?Ħ. How to Start Service Using Powershell Commands?ĥ. How to truncate the log in sql server 2008?Ĥ. What is the meaning of lock escalation and why/how to stop this?ģ. What is the difference between lock, block and deadlock?Ģ. ![]() Read following wires to be ready for this surprise: MSSQL Interview Question Clustering- Part1, Part2, Part3 and Part4ġ. Interviewers are testing at least basic knowledge of clustering. Go ahead with ten most important Microsoft SQL Server DBA Interview Questions. I observed that many interviewers are interested in finding out whether you worked on DB corruption or not. I have got many requests to publish first set of MSSQL DBA Interview questions. How to Handle Sexual Harassment at Workplace Following are some “sql server 2008 dba interview questions” to help you in interviews.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |