by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, MySQL
Finding and Terminating SQL Server Blocking Processes – Dead Locks in MSQL We can free or release or remove or delete or check all locks on the sql server 2008,2012 and 2014 objects like table etc by killing the process id which is keeping the locks on the...
by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, Uncategorized
How to detect if the disk space is running low on SQL Server. There are two different ways to do the same. I personally prefer method 2 as that is very easy to use and I can use it creatively along with database name. Method 1: EXEC MASTER..xp_fixeddrives GO...
by mawundaga | Jan 9, 2018 | MSSQL
You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach. With the use of T-SQL you can generate your backup commands and with the use of cursors, you can cursor through all...
Recent Comments