SQL Server Education (by the geeks, for the geeks)
Hi Friends, Here, I am going to introduce you with a very interesting thing about clustered indexes. We all knew that when we execute a particular select query then the required …
SQL Server Buffer Pool Part 2: Impact of Clustered Index on Buffer Pool Read MoreHi Friends, Here I am going to explain a problem which is asked by one of my friend. Problem: Let’s run the below query: USE master go create database PRINCE go …
SQL Server Fragmentation for the table having less than 24 data pages Read MoreHi Friends, Today, i am going to explain various things about the sql server buffer pool which is also known as buffer cache. Buffer Pool consist of various type of cache …
SQL Server Buffer Pool Part 1: Deep Look inside buffer pool Read MoreHi Friends, There is a very good option in SQL Server 2008 for Performance Optimization, i.e. “Optimize for Adhoc Workloads”. By using this option you can maximize the use of SQL …
SQL Server Plan Cache Optimization Using Optimization For Ad hoc Workloads Read MoreHi Friends, Today I am going to explain a very interesting thing about SQL server database transaction log files. Which is every database transaction log file maintain some space to rollback …
SQL Server Database Transaction Log Files – Virtual Log Files: Space Required to Rollback: Part 3 Read MoreHi Friends, Today, I am focusing on the use of an undocumented command DBCC DBINFO. By using this command you can get some more interesting information about SQL Server Database Information …
SQL Server Database Information Query – using DBCC DBINFO & DBCC PAGE Read MoreHi Friends, In my previous blog I just mention about what will be the number of Virtual Log Files at the time of creation of new database, where number of VLF …
SQL Server Database Transaction Log Files – Virtual Log Files: Circular Behavior: Part 2 Read MoreHi Friends, Today, I am going to explain the internal of SQL Server database transaction log files architecture by using DBCC LOGINFO. Our Transaction log file is just divided into multiple …
SQL Server Database Transaction Log Files- Virtual Log Files: DBCC LOGINFO: Part 1 Read MoreHi Friends, Today, I am focusing on very interested feature provided by Microsoft SQL Server for DBA people. This feature is “Database Backup Compression”. This feature first introduced in SQL Server …
SQL Server – Database Backup Compression – Faster Disaster Recovery Read MoreHi Friends, There is a very interesting option in SQL Server 2012 Management Studio “Import and Export Settings….”. This feature will allow you to Import and Export some SSMS settings as …
SQL Server 2012 Management Studio “Import and Export Settings” Read More