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,303 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
653 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
570 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,166 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,673 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,586 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
704 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
768 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
515 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers