[Video] Office Hours: Database Answers from a Hotel Room
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver.
Here’s what we covered:
- 00:00 Start
- 01:43 Poul J: Hi Brent. Can you give some examples of how a CHECK() constraint is used by the optimizer. Is it similar to a filtered index… Or is there more to it?
- 03:54 RadekG: Hi Brent, Could you explain when high wait statistics of parallelism type indicate a problem? I wander what is even a point in monitoring them… (but I am almost sure that I am missing something obvious here)
- 04:51 Ricardo: My secret-sauce as a DBA was getting sophisticated work done through the GUI (EG: Always On). Now with Azure Portal, Databricks, etc, the GUI seems to change daily. Do you think the days of the GUI are numbered? (the days of knowing a GUI intimately, like an engine bay).
- 05:45 tibbler: Hi, imagin you have complex structured data in a database. You’d like to archive them for long term, the structure should be preserved too. Would you recommand a database for this purpose?
- 06:57 Ricardo: When performance tuning what ball-park figures do you use relating [time] to [rows returned]. EG: What is a reasonable amount of time to return 200,000 rows in a report?
- 08:48 Ozan: Hi Brent, when using SQLQueryStress with enough number of threads and iterations to get THREADPOOL waits, i can still see enough available worker threads after summing up the active_workers_count field in dm_os_schedulers. How is that possible? Thanks
- 09:50 Andrew: How transferrable is Oracle DBA experience to the Microsoft stack? I’m reviewing job applications for someone on my team, we use the Microsoft stack, but have a few applicants with years of Oracle experience – do you see the concepts as equivalent or transferrable?
2 Comments. Leave new
pagination woo! 🙂
@Andrew – In my opinion – Applicants with ORACLE or DB2 for MS-SQL may come in with a deep understanding due to all the options. On the other hand there are large ORACLE shops where they segment duties. One person for Tables, another for files/memory, another for functions and one for backups. They may have been in a silo. If they ran SAP or PeopleSoft they may have not been able to make many changes.
SQL server is smaller. You may only have vendor apps to run. Run some normal tasks past them and see what they say.
I’ve learned far more fixing bad code and playing around than following instructions that worked perfectly.
Yes, I’m ORACLE and DB2 biased. They are good for what they do. Just like Excell or Access is good for what it does, but Excell and ACCESS are not a databases!!!!