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...
2012-02-09
1,696 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
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...
2012-01-31
4,570 reads
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...
2011-11-05
2,481 reads
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...
2011-10-31
1,731 reads
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...
2011-10-30
11,432 reads
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...
2011-09-19
6,818 reads
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....
2011-09-19
2,847 reads
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...
2011-09-05
1,485 reads
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...
2011-08-07
2,012 reads
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...
2011-07-26
886 reads
Blogs
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
Forums
Connect tabular model to excel via Power BI semantic model
I have a tabular cube, with myself included in one of the roles. I...
New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome
Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...
Helpful Management Studio Settings and Features
Comments posted to this topic are about the item Helpful Management Studio Settings and...
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers