Daily Archives: 10/18/2014

---

Sql Interview Question #6: What are pessimistic and optimistic locks?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged locks optimistic pessimistic server sql on 10/18/2014 by Blog Admin.

Sql Interview Question What are pessimistic and optimistic locks?

---

Automatic database restore using DateTime functions in SQL Server

This entry was posted in Sql Server DEV Sql Server tutorials and tagged database datetime functions restore server sql on 10/18/2014 by Blog Admin.

Scenario I have to restore a production database to a development database on a weekly basis in order to refresh the environment. Currently, I’m doing this process manually. Is there any way to script this out so it can be automated?  Check out this tip to learn more.   Solution If you take full backups […]

---