Author: Andrew

I am SQL Tech Blogger

Solving The Issue Of SQL Server Physical File Fragmentation

TweetSQL Server physical file fragmentation causes major performance issue in database, it happens when data is deleted from a drive and left small gaps to be filled by new data files. In File fragmentation the logical sequential pages are not…

Guidelines For SQL Database Performance Monitoring

TweetOverview Monitoring SQL Server databases and instances provide the necessary information to diagnose and troubleshoot the performance issues. Once its performance is tuned then, it has to be constantly monitored as everyday data schema. Its configuration changes may lead to…

Understanding SQL Server Transaction Log Architecture

TweetTransaction log is a log that maintains the record of every transactions that has occurred. It involves data modifications, rollback modifications and database modifications. It is a major part of database’s architecture. It records every transaction in an order by…

How to Take Table Level Backup In MS SQL Server

TweetOverview SQL Server is the database management system used for storing and retrieving data such as Triggers, Rules, Functions, Tables, and Stored Procedures. Users of SQL Server understand the importance of data backup that can help users restore and recover…

Troubleshooting Transactional Replication In MS SQL Server

Troubleshooting SQL Server Replication

TweetOverview Replication in SQL Server can be defined as the technique of copying and distributing data from one database to another database and then synchronizing between databases to maintain consistency. It helps in improving performance, easy maintenance reducing conflicts when…

Truncate and Shrink Transaction Log: What To Choose?

TweetTransaction file is the most vital element yet overlooked sometimes. The transactions carried out in the SQL Server database are recorded and logged into the transaction log database. This is why the file is named ‘Transaction Log Database’. There exists…

Microsoft SQL Server Index Performance

TweetAn index in SQL Server is a structure in association of which the speed of retrieval of rows from tables or views increases. It is comprised of keys that are associated or have been made from a single or multiple…

How to Add Data File to Mirrored SQL Server Database

TweetIntroduction The procedure of adding an SQL Server database to a principal database differs a lot relatively when database files are not placed in the mirrored and principal database on a similar path during Database Mirroring process. In the discussed…

Recover Deleted SQL Server Data From Transaction Log And LSNs

TweetEach database created in SQL Server contains a transaction log file to record transactions and the changes made to the transactions. It is marked as the demanding component since during the failure of the system these files helps to bring…