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?
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#5632 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "QRRFAW7rgVo"
["related_video_title"]=>
string(56) "Office Hours: Ask Me Anything About SQL Server and Azure"
["posted_time"]=>
string(21) "2 года назад"
["channelName"]=>
string(20) "Brent Ozar Unlimited"
}
[1]=>
object(stdClass)#5605 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "Ge3NvEwzMW0"
["related_video_title"]=>
string(142) "Авиакатастрофа Boeing 787 Air India, что случилось на самом деле? #авиация #самолет #boeing"
["posted_time"]=>
string(24) "10 часов назад"
["channelName"]=>
string(32) "Авиация в деталях"
}
[2]=>
object(stdClass)#5630 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "m11bAixX8OU"
["related_video_title"]=>
string(144) "🔴 СРОЧНО 100 ракет за ночь: Иран ударил по Тель-Авиву #новости #иран #израиль #сша"
["posted_time"]=>
string(24) "16 часов назад"
["channelName"]=>
string(17) "Один день"
}
[3]=>
object(stdClass)#5637 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "rqcwYyyI0ZI"
["related_video_title"]=>
string(176) "РУСТАМЗАДЕ: "Это было сюрпризом. Путин изменил тактику войны". Новое наступление, разгар, F-16, КАБы"
["posted_time"]=>
string(24) "19 часов назад"
["channelName"]=>
string(24) "И Грянул Грэм"
}
[4]=>
object(stdClass)#5616 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "JDw8Z_SrJ_I"
["related_video_title"]=>
string(55) "Office Hours: Ask Me Anything at the Barcelona Pavilion"
["posted_time"]=>
string(22) "11 дней назад"
["channelName"]=>
string(20) "Brent Ozar Unlimited"
}
[5]=>
object(stdClass)#5634 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "KbXEwH8EirQ"
["related_video_title"]=>
string(173) "[ НОВЫЙ 2025 ] Уральские Пельмени -Смейтесь без остановки вместе с комедийной группой №1 в России!"
["posted_time"]=>
string(21) "1 день назад"
["channelName"]=>
string(16) "Hanif Islamic Tv"
}
[6]=>
object(stdClass)#5629 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "ToOXpLtnD1c"
["related_video_title"]=>
string(79) "Арестович: В чем просчитался Трамп? @borovonovodvo"
["posted_time"]=>
string(24) "12 часов назад"
["channelName"]=>
string(17) "Alexey Arestovych"
}
[7]=>
object(stdClass)#5639 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "54JZUXQ_NXY"
["related_video_title"]=>
string(53) "Иран - Израиль. Конец планете?"
["posted_time"]=>
string(21) "1 день назад"
["channelName"]=>
string(27) "Анатолий Шарий"
}
[8]=>
object(stdClass)#5615 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "2yyYfe_b5sU"
["related_video_title"]=>
string(97) "История Linux и UNIX! Кто породил ВСЕ современные системы!"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(11) "PRO Hi-Tech"
}
[9]=>
object(stdClass)#5633 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "-yd59N2bWzQ"
["related_video_title"]=>
string(35) "Office Hours in the Detroit Airport"
["posted_time"]=>
string(25) "2 недели назад"
["channelName"]=>
string(20) "Brent Ozar Unlimited"
}
}
![[ НОВЫЙ 2025 ] Уральские Пельмени -Смейтесь без остановки вместе с комедийной группой №1 в России!](https://ricktube.ru/thumbnail/KbXEwH8EirQ/mqdefault.jpg)
