Mohsin Khan

Mohsin is a database expert with a decade of professional experience as a database administrator and architect. He has a master’s degree in Information Quality. He has accomplished many demanding targets and led and executed many multi-million-dollar projects for some big Fortune 50 companies. He has actively pursued mentoring and coaching others through various writing activities, speaking engagements, blog posts, and discussion platforms dedicated to data professionals. He likes messing around with databases and enjoys sharing his knowledge and experiences.
  • Interests: SQL Server, Data Science, Machine Learning
  • Skills: SQL Server, Data Science, Machine Learning

SQLServerCentral Article

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]

5 (6)

You rated this post out of 5. Change rating

2021-05-10

6,923 reads

Blogs

Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices

By

Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...

Building Effective Data Governance Framework: Top Areas to Focus On

By

The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...

Master the Foundational Basics

By

It tells us to take the time to master the foundational basics of whatever...

Read the latest Blogs

Forums

Linking 2 SQL Databases

By SimonLM

Hi All I am a complete novice so I apologise for any incorrect terminology....

How to write this query?

By water490

Hi everyone I have two tables storing stock prices.  Each table comes from a...

ssrs order of operation question

By stan

hi i need "sample size" in my report's 4th data region which is a...

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers