Category: MSSQL

Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)

In this article, I will describe a few of the most known types and solutions of this error. Possible Errors

We create Indexed Views by adding indexes to views. For detailed information about the View concept, I would recommend you

We can briefly define View as a virtual table that does not physically store records, and is determined by a

Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs

We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code

Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from

These roles are the default server level roles at the instance level. You can find the brief description about

In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL

Resource Governor announced with SQL Server 2008. We are able to limit resources of a session using Resource Governor.

The PIVOT , which is indispensable for Excel users, can be implemented with SQL Server 2005 via T-SQL. But I