Post reply

Hi any one please help in details about these below 

  • June 28, 2024 at 3:52 pm

    #4432199

    Hi any one please help in details about these below

    1.Database in recovery pending in SQL server cannot do any this what will you do to fix it

    2.How to stop recompile in SQL where wil you set in code or in db level properties

    3.How to check latency of always on and find slowness in secondary replica and fix it

    4.How to solve second in resolving state in always on and find it and fix it

    5. How to find database back is hung state and where to find and how to solve it

    6. Some sp is working fine before upgrade and after upgrading it's is not working how to fix it where will you set compatibility or what will  you do

    7.for a shopping management whole data is in a table which is having primary key int and there is no space left how to solve and we cannot drop the column as it is int primary key

    8.how will you deploy ssis package other than SQL server

    9. How will system know differential back is initiated to sqlserver

    10. In update statistics what is difference between  full and sample

    11. What is active and inactive log in sql server

    12. Virtual logfile means what

    13. What wait types you see in blocking for performance tuning

    14. How to find the text in spid with out using  dbcc input buffer or  by using which dmvs

    15. In replication distributor some tables are in struck how to see the laps of latency and find why it is stuck

    16. what is mean by Recovery acceleration of database

    17. Extend event and profile difference

    18. Query store how to enable and it's use

    Thanks
    Naga.Rohitkumar

  • June 29, 2024 at 4:10 pm

    #4432391

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 29, 2024 at 8:30 pm

    #4432416

    that's a decent list of interview questions to test if you have any experience doing any of those steps. i my self ask variants of some of these questions, and then ask even deeper, more probing questions about the same items to really flesh out the interviewee's experience.

    it would be better for you to try to explain your understanding of each question, and ask for confirmation or pointers. you could run these through google/bing/chatgpt as well, but it's questions to probe for experience it looks like ot me.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 1, 2024 at 1:17 pm

    #4432682

    If I answer the questions, what does the job pay and when do I start?

    Cause you wouldn't take my answers to those questions and submit them as your own to get a job on the false statement that it's your work, would you? You certainly wouldn't want to after posting this under your own name, right?

    If you literally can't answer any of the questions, maybe this job isn't for you. On the other hand, if you're stuck on a question, explain why and how you're stuck. I think any of us would be willing to help out. But I don't think you'll get anyone to do the work for you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 2, 2024 at 7:43 am

    #4432878

    If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering , so that if i miss anything I can cover up those as well from the replies given by the experts like you and many  

    Cause you wouldn't take my answers to those questions and submit them as your own to get a job on the false statement that it's your work, would you? You certainly wouldn't want to after posting this under your own name, right? ---> I have being collecting my own attended interview question save at one place and keeping them as a draft from last 12 years. 

    If you literally can't answer any of the questions, maybe this job isn't for you. On the other hand, if you're stuck on a question, explain why and how you're stuck. I think any of us would be willing to help out. But I don't think you'll get anyone to do the work for you. ---------> no one can get into the mind of interviewer what they are expecting , so many times we know one sort of answers but they want only one side , we can say many answers for one question but cannot get in to their mind , in those cases if we are not able to clear in to the job , at least by searching about the question they ask can make us alert for next time.  

     

    Thanks
    Naga.Rohitkumar

  • July 2, 2024 at 11:14 am

    #4432923

    naga.rohitkumar wrote:

    If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering , so that if i miss anything I can cover up those as well from the replies given by the experts like you and many  

    Cause you wouldn't take my answers to those questions and submit them as your own to get a job on the false statement that it's your work, would you? You certainly wouldn't want to after posting this under your own name, right? ---> I have being collecting my own attended interview question save at one place and keeping them as a draft from last 12 years. 

    If you literally can't answer any of the questions, maybe this job isn't for you. On the other hand, if you're stuck on a question, explain why and how you're stuck. I think any of us would be willing to help out. But I don't think you'll get anyone to do the work for you. ---------> no one can get into the mind of interviewer what they are expecting , so many times we know one sort of answers but they want only one side , we can say many answers for one question but cannot get in to their mind , in those cases if we are not able to clear in to the job , at least by searching about the question they ask can make us alert for next time.  

    Fair enough. It still looks like someone trying to get others to provide interview answers and appearances are enough in a lot of cases. If you think there's clarification or expansion needed, I'd want to see your answers first and then we can talk.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply