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
Divide by zero error
SSIS Interview Questions – Part 1
Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 3
Moving the tempdb database
Script to Check TempDB Speed
SQL Server buffer pool
View queries waiting for memory grant