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…
Category Archives: Performance
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…
