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,702 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,572 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,482 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,732 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,485 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,824 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,872 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,488 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,014 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
887 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers