Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
2018-05-15
12,599 reads
Indexing
2018-05-10
876 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
1,003 reads
2018-06-07 (first published: 2018-01-13)
2,407 reads
2018-06-15 (first published: 2018-01-04)
2,128 reads
2017-11-02
1,050 reads
Indexing for Windowing Functions: WHERE vs. OVER
Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.
2017-10-09
4,023 reads
2017-04-20
1,265 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers