PracticalSQLDba

An Effective Solution to Resolve SQL Database Corruption

• by nelsonaloor

• PracticalSQLDba

I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...

2019-09-25 (first published: 2019-09-17)

517 reads

SQL Server :Part 1 : Architecture of Transaction Log

• by nelsonaloor

• PracticalSQLDba

In our earlier post, we have discussed in detail about the architecture of the data file and different types of pages. In this post, we will be discussing about...

2013-10-01

8 reads

SQL Server :Part 1 : Architecture of Transaction Log

• by nelsonaloor

• PracticalSQLDba

In our earlier post, we have discussed in detail about the architecture of the data file and different types of...

2013-09-30

9,899 reads

SQL Server: Data File Structure

• by nelsonaloor

• PracticalSQLDba

In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...

2013-09-03

39 reads

SQL Server: Data File Structure

• by nelsonaloor

• PracticalSQLDba

In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...

2013-09-02

2,574 reads

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

• by nelsonaloor

• PracticalSQLDba

In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the differential backup process.In this post, let us try to...

2013-07-25

1 reads

SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model

• by nelsonaloor

• PracticalSQLDba

In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the...

2013-07-24

2,739 reads

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

• by nelsonaloor

• PracticalSQLDba

In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this post, we will try to understand the Differential Change...

2013-07-24

16 reads

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

• by nelsonaloor

• PracticalSQLDba

In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this...

2013-07-23

2,197 reads

SQL Server: Performance Tuning :Understanding Set Statistics Time output

• by nelsonaloor

• PracticalSQLDba

In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning. In this post we will discuss about the Set...

2013-07-18

3 reads