Recent Posts

The transaction log for database is full due to ‘LOG_BACKUP’

Sometimes you may face error “The transaction log for database is full due to ‘LOG_BACKUP'” this error due...

How To Add Line Numbers In SQL Server Management Studio (SSMS)

If we have enabled line number in SQL Server management studio for query text, It will very useful...

Identify the most expensive queries running on table

I was investigating SQL Server performance issue on a table where I was getting more locks, query timeout...

How to Install SSL Certificate on Linux Apache Web Server

SSL stands for Secure Sockets Layer, the protocol which provides the encryption. It provides secure, encrypted communications between...

SQL Server script to Rebuild/Reorganize fragmented Indexes

When on a database’s table frequently running INSERT, UPDATE or DELETE queries than we can see indexes on...