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
Script to Check TempDB Speed
PING all the Linked Servers and get a status report
Total Server Memory and Target Server Memory
Moving the tempdb database
SQL Server buffer pool
Log shipping Alerts failing to send emails
View queries waiting for memory grant