Lost in Translation – Deprecated System Tables – sysindexes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-01 (first published: 2012-10-29)
3,307 reads
StrateSQL
Last Weeks Top 10 “Reading” Links #4
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
655 reads
Reblog: October 19 to October 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-26
571 reads
PASS 2012 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2012-10-25
792 reads
Discovering Binary Pages In Sys.Indexes
In a previous post, we looked at how to take the the binary page values in sysindexes and convert the...
2012-10-24
1,175 reads
Decoding first, root, and FirstIAM in Sysindexes
Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…
“What do these values mean?”
Recently, I...
2012-10-26 (first published: 2012-10-23)
1,680 reads
What Happened to rowmodctr from Sysindexes?
In my blog series Lost in Translation – Deprecated System Tables, I’ve been going through the compatibility views in SQL Server...
2012-10-22
2,594 reads
Last Weeks Top 10 “Reading” Links #3
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-22
706 reads
Ask The Unicorn: SQL Saturday Registration Is Closed
Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led...
2012-10-20
770 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
519 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers