Hi Dave. The procedure create the script but this one is with the correct precedence or not? Suppose to have a SP called a_test that call, inside, the procedure b_test. Your suggestion create the procedure writing the b_test SP first and then the a_test SP or write the script in alphabetically order (first the a_test SP and the the b_test)? Thank you in advice for your attention.
Thankyou so much sir. I wanted to ask, is there any way to drop or truncate the table which is being accessed by othersL processes behind the scenes. Basically drop the table after unlocking it from others session_id
I have a performance problem for a particular client to solve this problem. Can sharding or partitioning on my mssql with client ID improve the performance of that particular client? Can you please take a video for horizontal and vertical sharding.
Thought everyone knew this stuff, suggestion for next video - working out what remote script is updating a given field in a given table... Aka which enterprise legacy code is messing up my data
Extremely great videos. Pinal recently I had an interview. The interviewer asked wht measures I would take if I expect a table to be very very large. Can u pls throw some light?
Great!, I would like a video on how I can get rid of a IN-Memory feature in my database having transformed all the In-Memory tables in Physical tables, please , I think only you can do it simply
@@PinalDaveSQLAuthority Thanks for your reply. Can you guide me to the right tool that could do that? If it is PowerShell/cmd, what should I search for?
Thank you so much for this video and yes we want a video on 100 percent CPU utilization
Will build that
Thank You, Pinal
Yes, we really need your videos for SQL SERVER.
Noted!
Love your stuff, Pinal. Keep it up.
Much appreciated!
Yes , looking forward for your 100% CPU utilisation vedio
Coming soon
Hi Pinal, yes please... that video of CPU at 100% will be great to learn about that situation... .. since now thanks you.
Coming soon!
Hi Dave. The procedure create the script but this one is with the correct precedence or not? Suppose to have a SP called a_test that call, inside, the procedure b_test. Your suggestion create the procedure writing the b_test SP first and then the a_test SP or write the script in alphabetically order (first the a_test SP and the the b_test)?
Thank you in advice for your attention.
They are all alphabetically ordered
This one was like we are walking and some one gave a Candy chocolate - This is Fantastic tip, i like it
Thanks a lot.
Thankyou so much sir. I wanted to ask, is there any way to drop or truncate the table which is being accessed by othersL processes behind the scenes. Basically drop the table after unlocking it from others session_id
You just have to wait for them to unlock.
@@PinalDaveSQLAuthority thank-you
Yes , please share with us.
Thanks.
Sure.
Hi Pinal Sir,
I really need that CPU 100% , your blog is simply awesome and videos are superb.
Sure!
Suggest something to solve the CPU utilization getting full issue… thank you
Let me check
I have a performance problem for a particular client to solve this problem. Can sharding or partitioning on my mssql with client ID improve the performance of that particular client? Can you please take a video for horizontal and vertical sharding.
Good idea.
Yes, please do a video in detailed on 100% CPU utilisation.
Sure Coming soon!
Yes, please make a video on what to do when CPU is at 100% utilization. Thank you.
Will do!
Hi Pinal Dave, Do you know, how to update db name in maintenance plans scripts?
This I have no idea
@@PinalDaveSQLAuthority me too 🤣
Nice video and agree with cpu video creation, thanks.
Thank you!
Yes we are waiting for that video
Coming soon!
Please make video on how to password protect my database file, no one can attach it with another instance of SQL Server
sure
Thought everyone knew this stuff, suggestion for next video - working out what remote script is updating a given field in a given table... Aka which enterprise legacy code is messing up my data
Thanks a lot!
Extremely great videos. Pinal recently I had an interview. The interviewer asked wht measures I would take if I expect a table to be very very large. Can u pls throw some light?
They may be looking for answer in terms of Partition
Yes, please do a video on 100% CPU Utilization.
Coming soon!
Yes, I really need the video of 100% CPU consumption issue by SQL server.
Sure!
Yes we always want to learn new things
Will build new videos.
Yes sir, we want video on 100% CPU utilisation
Ok coming soon
@@PinalDaveSQLAuthority Thanks Sir, I faced this issue in every morning.
Yes we want a video about Cpu 100% utilisation
I will work on that next.
Yes sir we do want on this topic..
Will focus on that topic.
Great!, I would like a video on how I can get rid of a IN-Memory feature in my database having transformed all the In-Memory tables in Physical tables, please , I think only you can do it simply
Great suggestion!
Thank you Very Much sir
So nice of you
Yes. Thanks!
Welcome!
Thanks for the video, a relevant question, can we automate the process generating scripts? "Database > Tasks > Generate Scripts"
Not via SQL.
@@PinalDaveSQLAuthority
Thanks for your reply.
Can you guide me to the right tool that could do that? If it is PowerShell/cmd, what should I search for?
please reply how can we automate this process on Linux server? I have a requirement to schedule this task daily on SQL server 2019 BDC
yes excited for new video
Sure will work on it.
Yes. Do you want a topic on XML? Why can't you read the basic XML definition from the SSRS catalog?
I am not sure. I use very less XML in my routine work.
Simple techniques but it save my time
Thanks
yes please!
we do want that.
Great
Yes we need video
Sure
Please a video on Sch-S VS Sch-M / With(NoLock) VS Rebuild & Sp_Recompile
will do.
Yes pinal... We want video for cpu 100 percent
Working on it.
Yes we need
Thanks!
Yes, Give a detailed video
Sure
Waiting for vedio on 100% CPU Utilization.
Sure very soon.
Yes sir
Will do
Yes
Great.
great
Thanks!
CPU 100% usage alarm!
So true
Waiting for the vedio of 100% CPU
Coming soon
Cpu 100 percent utilisation
Great
yes
Great
Please upload videos bit more frequent. Thanks
I will try my best. Meanwhile, do not forget to watch all the older videos.
Y
Sure
Yes, please
Server machine out of memory .........
Idea for new video.
Yes we want to know cpu 100%
Sure.
Your SQL Jamsbond
Thanks!
yes
Great
yes
Will create one.