Latest from the Blog
Deleting Duplicate Records
Have you ever needed to delete duplicate records from a table? If there is only one duplicate in a table then simply running something like DELETE FROM Table WHERE ID = @DupRecord will do the trick. What happens when the problem is found after multiple records are duplicated? Will tracking them all down be more … Continue reading Deleting Duplicate Records
Turn On Trace Flag 3226
A few days ago, we looked at how to check for enabled trace flags and how they are turned on/off. Today, let’s look at how trace flag 3226 alters the way SQL Server logs backup information. So Many Backups How many databases are you managing on an instance? Only a few? Maybe a few hundred? … Continue reading Turn On Trace Flag 3226
Customizing With Trace Flags
Trace flags are used to turn certain settings on or off in SQL Server. They can range from suppressing backup logs to affecting query plans. While some can be turned on from the beginning of a SQL Server install, you may be more likely to turn a trace flag on as a result of dealing … Continue reading Customizing With Trace Flags
- September 2021 (5)
- August 2021 (9)
- July 2021 (7)
- June 2021 (9)
- May 2021 (8)
- April 2021 (8)
- March 2021 (8)
- February 2021 (8)
- January 2021 (9)
- December 2020 (10)
Get new content delivered directly to your inbox.
