Thanks, could you help me with some more details like evidence which helps me make my case in proving so instead of saying it is not going to help with...

Ok thanks, could you share your thoughts on the below. The code below is part of SP. The problem I am trying to resolve is "Selecting all instead of required"

SELE

--...

• This reply was modified 5 years, 3 months ago by  sizal0234.
• This reply was modified 5 years, 3 months ago by  sizal0234.

Thank you! for the guidance. It helps.

Finally I get some help. Thank you!

I would really would like to look into how to use 'Setup.exe /q /ACTION=Repair /INSTANCENAME=instancename' properly.

I am sorry..we do repairs only when there is...

Thanks for the bump. I appreciate it.

Maybe I posted the question with incomplete information I do not know. I always had the idea of using powershell for installs like repairs...

Hi There,

Need little help. What version of AdventureWorks sample DB is being used in "Stairway to SQL Server Indexes"

I see some difference while running sample queries in my Adeventureworks2017 DB.

Thanks!!!

🙂 I agree performance issue needs to be addressed. Step 1 was run SP blitz and remediate the issues. Need to look into different areas and CODE for sure.

Couple of...

I looked into it already and due to some reporting the CPU spikes up to 60%. I discussed about moving reporting from prod to somewhere else however it is like...

Thank you all, It helps!

Yeah however would like to know the difference. Thanks!

Great. Thanks!!

You are right!. Being diligent is extremely important. I even had situations where Developer did NOT mention DB name or commented the DB name and Available DB ( CTRL...

Thank you All..It helps and will plan and have custom list for my environment.

Thank you for your advise. Could you please elaborate on Smoke tests.

Yes, we do have SQLcerntry one client for Prod instance ONLY so that does show CPU usage etc.

Thanks for your reply.

Let me check how they are trying to deploy and will get back to you. I am sure it is TFS however not aware of the complete...

I apologize for the double post. I am not sure how that happened.

Will be careful nextime 🙂

Appreciate your time and answer.