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
Log shipping Alerts failing to send emails
Find the modified date of SQL Server Agents Jobs
Divide by zero error
SSIS Interview Questions – Part 1
Moving the tempdb database
Script to Check TempDB Speed
SQL Server buffer pool
View queries waiting for memory grant