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,694 reads
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,694 reads
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,569 reads
As a learner I have got chance to know lots of free and precious SQL Server resources in last few...
2011-11-05
2,476 reads
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
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,224 reads
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,808 reads
“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,823 reads
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
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,011 reads
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
884 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers