When I was thinking up names for this blog, I had a hard time not using the name my husband uses for his fantasy baseball team: The Stellato Heels. It’s great, isn’t it? I can boast about how fabulous it is because I didn’t think of it. I had great visions for the logo. Just…
Desperately Seeking Seeks
This month’s TSQL Tuesday topic (follow Twitter hashtag #TSQL2sDay) is hosted by Michael J. Swart ( blog | Twitter ) and the topic is, “What are your thoughts on Database Indexes?” One of the most powerful features of indexes is that they can provide a performance benefit without requiring a change to the underlying code. This…
All things in moderation
This past Tuesday I had the privilege of moderating the SQL PASS Performance Virtual Chapter LiveMeeting. Andy Warren ( blog | Twitter ) presented an Introduction to SQL Server Statistics, which you can view here. This is the second time that I have been the moderator for a LiveMeeting, and I thought it worth sharing…
Read-only Filegroups, Page Splits/sec and Error 825
You may wonder what these three things have in common. Before you try to play Carnac the Magnificent, humor me for a quick and high-level review of each. A read-only filegroup is one from which data can only be read, not written or updated. Fairly obvious, but it’s always good to define terms. Before marking…
