2013-08-08
5,521 reads
Shashank Srivastava
Orphaned Distribution Transactions
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
2013-07-16
5,214 reads
Change the Maintenance Plan Owner
This article shows how you can change the maintenance plan owner in SQL SERVER
2013-07-02
7,630 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
2013-05-16
41,163 reads
Blogs
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Daily Coping 8 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
MAX not working with a CTE
I have a query that is supposed to return one patient id but even...
doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'
i have a cursor that runs on all my views and then exec...
Transaction log full error 9002 on Alwayon Availability groups
Hi All, I am looking for some inputs on how to avoid or prevent...
Ask SSC