Скачать с ютуб Office Hours: Tel Aviv, Israel в хорошем качестве

Office Hours: Tel Aviv, Israel

Ask me anything about SQL Server and Azure at https://pollgab.com/room/brento and upvote the questions you'd like to see covered. Here's what we covered this week: 00:00 Start 00:55 Manikandan GS: As postgres being one among the RDBMS lane, do you think postgres is having more features and flexibility compared to MS-SQL Server? 02:46 PaginationWoo!: Hi Brent. I use Ola’s script to update stats nightly. Other than time spent and % CPU used, is there a case where updating stats with fullscan would be a bad thing? I’m fortunate in that I have a long maintenance window. If I have time for fullscans, wouldn’t it be worth doing? 04:42 Adza: I had the thought of creating a date table with all dates ranging from 2010 to 2070 and have a smallint key for each date. Then in my tables I can store smallint values instead of actual dates. This could be a huge data saver (2 bytes vs 3 bytes). Smart or stupid? 05:53 Eyes Without a Face: Is there a portable version of the First Responder Kit? Our customers are mainly banks and they are not keen to install Stored Procedure. Not even the First Responder Kit 06:44 Dawson from Dawsons Creek: Do you have any clue why Microsoft suggests to use a windows collation for new development work but the default server collation for English(US) is still a SQL collation? For all other Windows locale the default server collation is a windows collation. 08:07 StillLearning: Hello Brent, as a Dev DBA I've recently became increasingly frustrated with computed columns and their limitations (filtered index...). Should I advise the dev teams to refrain from using them and do the computation in the app instead ? Thanks 09:26 Haurun: What are the pros/cons of installing Ola Hallengren maintenance script tables / sp's in master database vs some kind of maintenance db? 10:42 Milind: Hi Brent, Thanks for your time. During execution of certain queries or SPs I am observing high logical reads. Where should I look to make sure it is appropriate or required improvement? Unfortunately, I haven't completed all the training modules and asking this question. 12:06 TheCuriousOne: Hi Brent! If you have to work with local SSDs in a server for your SQL setup, is it better to have one big array with OS side logical separation through partitioning or to have physical separation by setting up smaller disk-sets with various RAID configurations?