SQL Server Storage Internals Part 3 - Architecture of Heaps
In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...
2010-12-19
5,571 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-16
15,102 reads
SQL Server Storage Internals Part 1 - Basics
While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...
2010-12-13
6,800 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-08
3,073 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,422 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers