What is Statistic in Sql Server Part - 2

Interview Question : Does sp_updatestats update the statistics of a table if I just run it or does it use specific formula??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 3

Difference Between varchar(max) and varchar(8000)

SQL Server System Databases

 Many people does know about system databases but no one remembers detailed version and get confuse in tricky questions. So I have put this in points

Master Database :

1. 
   

SQL Server ACID Properties

Difference Between Mutex vs Semaphore

How to delete Transaction log file in SQL server : Demo

Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

When dbcc checkdb last run OR Frequency of checkdb

What is the Difference Between Rebuild and Reorganize indexes ; Interview Question

What Is The Difference Between Checkpoint And Lazy Writer : Interview Question

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 3

How Sql server Deadlock Mechanism works

Deadlock Detection

Note: To enable deadlock , Please refer : How To Enable Deadlock Trace in Sql Server

 Deadlock detection is performed by a lock monitor thread that periodically initiates a search through all of the tasks in an instance of the Database Engine. The following points describe the search process:

SQL Serer Page Types

SQL Server architecture ( Interview )