Thnx for sharing! I would just add that setting MAX DOP in the DBCC CHECKDB or index maintenance (OLA) command is necessary only if your server MAX DOP setting is not good enough (like sharepoint) because OLA script takes global MAX DOP settings if you didn't explicitly specify differently in the command.
I am moving over to SQLServer from the SYBASE world. In many cases we used non clustered indexes as our PK and clustered indexes to reduce contention for the last page. In current MS SQL is best practice to clustered on the PK ?
lol I just built some new SQL servers just after we added a few hundred TB of SSD allowing us to get rid of our spinners and I set up every log drive in its own volume not even thinking about it. On index re-orgs - does SQL 2017 and 19 update statistics now?
Where can I read / understand more about your comment on things change and having data / log files on separate drives doesn't make much sense anymore. I'd like to dig into that rabbit hole more if you can link me that specific video - Thanks
![[UNCUT]“ฅนตื่นธรรม”ปะทะ“หมอปลา-ปู่มหามุนี-อั๋นโอกิ”สะเทือนกระทรวงเวทมนตร์ Iคนดังนั่งเคลียร์I10 ตค.67](http://i.ytimg.com/vi/peMD_SAkwNc/mqdefault.jpg)
One skill that every IT-person should have: check how long ago an video was posted. 🙂
Thnx for sharing! I would just add that setting MAX DOP in the DBCC CHECKDB or index maintenance (OLA) command is necessary only if your server MAX DOP setting is not good enough (like sharepoint) because OLA script takes global MAX DOP settings if you didn't explicitly specify differently in the command.
You have an awesome content! Muchas gracias Brent!
Glad you like them!
Saving your playlist.. ❤️
I am moving over to SQLServer from the SYBASE world. In many cases we used non clustered indexes as our PK and clustered indexes to reduce contention for the last page. In current MS SQL is best practice to clustered on the PK ?
Yep!
lol I just built some new SQL servers just after we added a few hundred TB of SSD allowing us to get rid of our spinners and I set up every log drive in its own volume not even thinking about it.
On index re-orgs - does SQL 2017 and 19 update statistics now?
Thanks Brent, any recommendations on running Ola Hallengren index maintenance scripts for VLDBs on daily basis
I don't have a video I can point you to at this time, no.
Where can I read / understand more about your comment on things change and having data / log files on separate drives doesn't make much sense anymore. I'd like to dig into that rabbit hole more if you can link me that specific video - Thanks
Sure, check out my Mastering Server Tuning workshop.
Hi Brent, We see in our Database, tables are getting fragmented frequently.. any lead and direction for such behavior ?
Yes, watch the video. ;-)
great content!!!
Thanks!
Thank you sir