Pages

▼
Thursday, 1 August 2024

SQL Server Internals Explained: An Introductory Guide

›
Understanding SQL Server's internal architecture and components, such as the Relational Engine, Storage Engine, indexes, and locking mec...
Wednesday, 19 June 2024

Some common reasons why the transaction log cannot be reused automatically

›
Managing SQL Server databases may sometimes be challenging especially when it comes to dealing with transaction log file internal space usag...
Monday, 13 May 2024

Boosting SQL Server Efficiency: Why You Should Update Statistics Manually

›
While SQL Server provides automatic statistics management, manually updating statistics allows for greater control over database performance...
Saturday, 20 April 2024

Detailed Explanation of SQL Server Query Hints

›
SQL Server query hints are directives that can be included in your SQL queries to guide the SQL Server Query Optimiser in executing them. Ty...
Monday, 4 March 2024

Understanding the SQL Server Query Optimiser: A Comprehensive Overview

›
The SQL Server Query Optimiser is a crucial component of Microsoft SQL Server, responsible for determining the most efficient way to execute...
Monday, 12 February 2024

Detecting Poor Cursor Usage in SQL Server

›
Undoubtedly, poor cursor usage is a critical issue to review in order to mitigate the risk of CPU bottlenecks and to assess whether cursors ...
Wednesday, 17 January 2024

Looking deeper into the physical & logical architecture - Transaction Log File

›
Beyond all doubt, it is essential to have a good understanding of the Transaction Log (T-Log) so that we can diagnose unforeseen performance...
Sunday, 17 December 2023

Getting Important Information of SQL Server Backups

›
Regardless of the method employed to take SQL Server backups, they must be carefully monitored around the clock, particularly in critical da...