Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]
2007-09-09
3,604 reads
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
I am having great trouble creating a data pipeline using MariaDB connector 3 with...
Dear Friends, Please advise why would one of my Availability Group databases go into...
Access db wanting to move sql server, how much control does business have over...
Ask SSC