Real time MS SQL Server DBA Experienced Interview Questions and Answers - Interview 1
Vložit
- čas přidán 25. 08. 2024
- Join this channel to get access to perks:
/ @mssqldbatechsupport
Join the whats app Group for the scripts and assistance:
chat.whatsapp....
You Can Also Download the scripts from below folder
drive.google.c...
We strongly believe there is always chance of betterment, so suggestions are most welcome.
Happy learning, and best of luck in your professional journey!
The journey of improvement is ongoing and never be an end.
Thank you!
MS SQL DBA Tech Support
thanks, pls do more videos ,it is help full for ours, we always support your channel,Greate work
Thank you, I will
Thanks for your efforts Harsha you are giving excellent info to DBA people
Thank you so much 🙂
Thanks 👍 👍..
Please make this type of video on regular basis
Sure 👍Ok. Thanks
Thank you for your video ,Please fix audio issues in video
Thanks and will work on it
I think sequence is like this :
MASTER
MODEL
TEMPDB
MSDB
Model comes online first , because model holds tempdb template . If incase model is corrupted or not available , MS SQL won't come up as tempdb won't be created in such case . Each time sql service restarts , tempdb is created
yup...we can see these details in error log as well.
@@MSSQLDBATechSupport : But @17:50 you told him Tempdb is second system db to come up. it should be Model .
i also told... u get this in readerrorlog
Your way of questioning very nice
Keep watching
Thanks for helping us 👍
It's my pleasure👍
Please do make more vedios of such for dba interview real time ones. Thanks
Hi Ganavi
up to now we have conducted 16 interviews and all there in this playlist.
czcams.com/play/PL-xn4QSr30HZEx3bBnFLgjVj8aJ2zRrSu.html&si=qkyaFRkn6lF0IvSC
thank you so much
Welcome 😊
The interview is wrong on snapshot. You can't restore from snapshot to different server, that's not how snapshots work.
Yes.we cannot restore like that. Here is the video about differences
czcams.com/video/dKhTbJ7dYzA/video.htmlsi=gkCzUd0GviVZwlwQ
Nice information 👍
Thanks and So nice of you
BHai confuse ho raha hai... Nervous bhi ho raha hai.... Koi baat nahi... Don't loose ur cool... Whatever may... U may pass u may not.. There r so many other interviews waiting for you.
Thanks for expressing your kindness
Thank you so much 😊
You're welcome 😊
Thanks
Welcome
the scripts drive folder is not accessible
whenever there is change in new links or whatever... we cant change in old videos description for all videos.however u can get it new information about links in new videos description
How to move temp data file in one drive to another drive
Here is the video about tempDB move
czcams.com/video/mapW57EDGeA/video.htmlsi=Pa10iEaIoiv0Fc5I
hi the scripts folder is not accessible
whenever there is change in new links or whatever... we cant change in old videos description for all videos.however u can get it new information about links in new videos description
Tempdb through the alter command we can move
Yes we can change using alter command.
What and all interview questions were asked all those were showed in our you tube channel.
nice way
Thank you! Cheers!
How to join realtime experience classes
We are not taking any classes.. and we are sharing our experiences as tasks what we get in our day to day DBA life... you just go through our videos and learn and make notes of it.
What do you use to clean the cache?
we use DBCC FREEPROCCACHE; to clear plan cache
@@MSSQLDBATechSupportcan you do a video about performance? Thank you
sure...will do
If interested you can our telegram group for Clearing your Queries
t.me/mssqldbaworld
Sir sound konchem disturbing ga undhii clear ga vinapadtledhu
Sorry for the inconvenience caused.will take care further
@@MSSQLDBATechSupport tq so much anna can you provide interview questions in pdf...
i don't have interview questions in pdf. i will go with flow. Please comment the question which you feel tough to answer.i will reply answer to that question.
I think the guy has failed in this interview... Last question ka answer hai leadblocker check karna
This is the stepping stone who are preparing for the next phase in DBA industry
I need a ms dba
Use below link to join the MS SQL DBA whatsapp group and ask technical doubts what u had
chat.whatsapp.com/L8QlUf0zRCO8v0YiG7cC1r
Link doesn't work sir
we moved to telegram and below is the updated link
t.me/mssqldbaworld
Master
Tempdb
Model
Msdb
Resource db is also a system database and by default it will be hidden
Hi Harsha
i want to contact you
Sure. you can reach out to me
mssqldbatechteam@gmail.com
Sp_helpdb hear we can see all db ids and all
Yup... we can get it from SP_helpdb as well