Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Transactions

1
November 17, 2012  2:00 PM

Backup Databases on Creation



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, CREATE TRIGGER, Data Loss, Database, Database Administration, DDL Trigger, Recovery, SQL Server, SQL Server 2008 R2, SQL Server 2012, T/SQL, Transactions, Trigger, xp_create_subdir

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

June 7, 2011  9:00 PM

Taking locks without doing SELECT WITH UPDLOCK



Posted by: Denny Cherry
Lock Pages, sp_getapplock, sp_releaseapplock, sys.dm_tran_locks, Transactions

All to often developers need to force some locks on a table so that they can be sure that the records aren’t going to change between the time that they first look at the records and when the transaction is completed.  The most common method that I’ve seen to do this involves at the top...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

1