So in my day job I was asked to investigate why some data was not matching up. After a bit of investigation I found a table that had 90-95% of it's records duplicated, so I needed a way of removing...
There are many ways of detecting duplicate data in your tables. One of the quick and easiest methods I have found is to use the below syntax.It will return a list of duplicate entries by the...
Database stuck in “Restoring” state
Find the modified date of SQL Server Agents Jobs
Log shipping Alerts failing to send emails
Divide by zero error
Script to Check TempDB Speed
Moving the tempdb database
SQL Server buffer pool
View queries waiting for memory grant