Most Used Database Files - SQL in Sixty Seconds 190

Join this channel to get access to perks:

0:00 Intro
0:11 Real-World Scenario
0:48 Demo: Most Used Database Files
2:04 Final Note

Script Used in Demo:

#SQLServer #PerformanceTuning #SQLAuthority

[dsuess]

Wish i had this little gem back when working in the product support group years back. Still going to use it today to during system testing to assist in uncovering inefficiencies.

Love the tips, Pinal!

[zanonilabuschagne]

Compliments of the season to you, Pinal.

Thank you for this one, it is a really useful script to have!!!

[mtsurov]

Pinal, could you please also cover the "Why' part in your 'How' videos.
Example: Why do you need to know most used DB file.
This would really help those of us that are 'accidental dba's'
Overall really like your channel. Quality stuff and good use of our time.
Cheers. 🙂

P.S. Turns out i had to watch the video to the end to see the 'Why' part.

[adityagurav]

Pinal sir aap video editing ke liye kaunsa software use karte ho ?

[chrgbhtt]

Very useful tip 👍. Can you please make one on partitioning - When/how to use it for lifting the performance.

[yoginiranjan]

Thanks and good one! but how do we know what queries making them - particularly ? because so many queries may access that mdf file. do have any scripts for this ?

[HemantGupta]

I am a great fan of your work, I have a different question than the subject of the video
I have a multitenant application, where each tenant has its own DB, how can I push script updates to all the tenant DBs efficiently?

[AnilArjunKumar]

Hi sir, I have done some mistakes in update query, total table data has been updated, how to undo the old table.

[kotasuresh]

Namaskaram, pinal dave garu, how do we know which file is slow from the result set

[TheUttamkumarbagchi]

how many years stored data can be saved or need archived?

[brunocampoli]

Is there a way to remove read bytes caused by backup ? Thanks !