Here’s my first five SQL Server Quick Tips:
Shrink database or shrink file operations CANNOT be run during a database or transaction log backup #sqltip #sqlserver #sql2012
— Jens Vestergaard (@vestergaardj) november 2, 2012
To edit an alert,you need to be either member of the sysadmin server role orSQLAgentOperatorRole db role in the msdb db #sqltip #sqlserver
— Jens Vestergaard (@vestergaardj) november 3, 2012
Support for tape backup devices will be removed in a future version of SQL Server #SQLTip #SQL2012 #SQLServer — Jens Vestergaard (@vestergaardj) november 6, 2012
When transactional replication is enabled, SELECT INTO operations are fully logged even under Bulk Logged recovery model. #SQLTip #SQL2012
— Jens Vestergaard (@vestergaardj) november 8, 2012
Trace Flag 1204 returns the resources and types of locks participating in a deadlock and also the current command affected. #SQLTip #SQL2012
— Jens Vestergaard (@vestergaardj) november 9, 2012
