|
 |
 |
 |
 |
 |
| |
Some links on Clustered Indexes
- Afraid of SSD? - Use The Index, Luke blog 2013-07-02
- Solid-state drives: Changing the data world - IBM
- SQL Server- Table partitions on SSD - Database Administrators Stack Exchange
- How clustered index stored on disk? - MSDN (basic info, nothing on SSD's)
- Tables without Clustered Indexes? | Basit's SQL Server Tips
My thoughts:
- SSD's are a huge game changer to database design, but a well designed clustered index will still help.
- Sometimes, you will get a Holy War on how Clustered Indexes, and especially Table Variables, work.
Yet, many times the database software company, holds their cards close to their chest as the "exact way the aforementioned work, are TRADE SECRETS. Hence the documentation will only say as much as needed without letting the competition, including, open source, know how it "exactly" works.
You will get one "expert" or MVP with 10+ years of experience saying this and another expert saying something else. I also got myself into a holy war argument on table variables.
Regardless, with SSD's, the holy war arguments are more or less settled to a degree and we should be getting back to serving the needs of the customer.
|
|
|
| |
|
|
|
|
 |
 |
 |
 |
|
|
Clients | Services | Contact