Database user and programming tips
Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.
Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.
Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.
There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.
In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.
Have you ever wanted to know who made a schema change to your database? If so, read on to learn how.
Have you ever wondered how to find the worst performing TSQL queries on your instance? If you have, you are not alone.
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.
Database User and Programming Tips Archives