Technology
Are you giving yourself a HEAP of trouble by using tables with no clustered indexes? But it is faster you say . . . because you don't have to worry about the sorting when inserting. Our guest Rick Lowe suggests everything is fast until you decide to SELECT, UPDATE, or DELETE. We talk about why you may or may not want to use HEAP tables. I know I was surprised to get his take on the use of HEAP tables and I think you will be, too. Do you agree with our assessment? Let us know in the comments on the show notes page.
The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/25/episode-142-do-you-have-a-heap-of-hurting. Have fun on the SQL Trail!
More Episodes
Episode 200: Anything but the Cowboys . . .
2020-06-25
2020-06-25
Episode 199: Technical Debt
2020-04-30
2020-04-30
Episode 198: Cloud Infrastructure
2020-04-23
2020-04-23
Episode 197: Power Query in Power BI
2020-04-15
2020-04-15
Episode 196: Teleworking
2020-04-02
2020-04-02
Episode 195: Understanding DAX
2020-03-26
2020-03-26
Episode 194: PolyBase Use Cases
2020-03-19
2020-03-19
Episode 193: Power BI Premium
2020-03-12
2020-03-12
Episode 191: Power BI Row-Level Security
2020-02-12
2020-02-12
Episode 190: SQL Server 2019
2020-02-05
2020-02-05
Episode 189: Power BI Common Data Model
2020-01-23
2020-01-23
Episode 188: Databricks
2020-01-16
2020-01-16
Episode 187: Power BI Performance Tuning
2020-01-08
2020-01-08
Episode 185: DBATools in a Month of Lunches
2019-12-19
2019-12-19
Episode 183: SQL Server Big Data Clusters
2019-12-04
2019-12-04
Episode 182: XEvents
2019-11-21
2019-11-21
Episode 181: Paginated Reports in Power BI
2019-11-13
2019-11-13
Get this podcast on your
phone, FREE
