Рет қаралды 1,561
Let's hang out in the pool in Cabo and go through your top-voted questions from pollgab.com/room/brento.
00:00 Start
01:00 OpportunityKnocking: What are your thoughts on when to implement a NoSQL strategy over traditional RDBMS for large enterprise-wide database platform solutions? I see scalability advantages in using NoSQL but do you see this becoming more of a preferred go-to solution for organizations over time?
01:57 SwissDBA: In a table with 8M rows, 2 GB data + 4GB indexes, Clustered ix on a GUID column. INSERTs are slow bc SQL has to squeeze them in between existing rows. I would switch the clustered ix to a new IDENTITY column, so new records can be added at the end of the tbl. How would you do it?
03:01 MyTeaGotCold: You recently said that your Hekaton clients are trying to get off. The faults of Hekaton are well-known, so what changed between when they started using it and now?
03:54 Tim Rogers: 90 TB database in AWS, all data active. Tables partitioned across 100 filegroups (4 files each) for ease of index maintenance. Would like to consolidate to a single "data" filegroup with ~100 files, because we don't do anything that benefits from multiple filegroups. Thoughts?
06:30 Kevin M: Would like to learn Amazon Aurora despite current company not using Amazon stack. What's the best / cheapest way to learn Amazon Aurora?
07:47 SadButTrue: Hey Brent! Who's the "Brento" in Postgres community?
08:26 RadekG: When was the last time that you faced a query so poorly written that you had to have a drink before fixing it? What was so bad about it?
11:19 Jökull: What are the top issues you see when storing / searching XML/JSON in SQL Server?