Indexes That Have Not Been Used but Are Being Updated
Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.
2018-06-12
3,648 reads
Indexing
Why Are You Dropping and Recreating Your Indexes?
Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?
2018-05-22
5,535 reads
Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
2018-05-15
12,463 reads
2018-05-10
869 reads
Missing Index Impact and Join Type
Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.
2018-04-26
7,058 reads
When Does Index Size Change Index Choice?
Erik purposely fragments indexes trying to slow down queries.
2018-02-15
3,508 reads
2018-02-06
973 reads
2018-06-07 (first published: 2018-01-13)
2,366 reads
2018-06-15 (first published: 2018-01-04)
2,090 reads
2017-11-02
1,044 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...