Data Page math : 96 + 8060 + 36 = 8192. is this correct?

I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...

Important SQL Notes collection by Jose Barreto

I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single...

Free SQL Server Learning Resources

As a learner I have got chance to know lots of free and precious SQL Server resources in last few...

Four faces of an Employee

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take...

Logical CPU, Physical CPU and hyper threading

Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...

Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers

One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...

Father of SQL Server?

“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server....

Youngest MCM in the world?

As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...

Chennai SQL Server User Group and me

My one week long search to identify active SQL Server community in Chennai ended last Sunday.
Chennai SQL Server User Group...

SQL Server, Chennai and Me

It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...