Viewing 15 posts - 1 through 15 (of 83 total)
As a precaution, I always confirm before deletion and also script the SP's and save them on separate drive for couple of days so that I can recreate them if...
November 12, 2019 at 9:45 pm
Now, at least I am ready with clear answers when I see blocking.
Obviously, fixing the root cause is deep. I work in an environment where there is lot of...
November 6, 2019 at 7:43 pm
Thanks!!!, I ran the script for test scenario and below are the results..
HEAD - 71 USE AdventureWorks2012 BEGIN TRANSACTION --rollback --commit SELECT * FROM [dbo].[DatabaseLog] WITH (TABLOCK, XLOCK, HOLDLOCK)
November 5, 2019 at 10:42 pm
Sure, I will have a look at the execution plans. Thank you!
October 21, 2019 at 5:47 pm
Not a big performance improvement however replacing * where ever not needed. Since tb's have billions of records and '*' can or maybe a bottleneck...if anything the code tries to...
October 21, 2019 at 5:37 pm
Here is the sql below:
@profile_name = 'EXAMPLE',
@recipients = 'EXAMPLE@EXAMPLE.com',
@from_address = 'EXAMPLE@EXAMPLE.com',
@subject = 'TEST - EXAMPLE Scripts',
@body = 'EXAMPLE UPDATE'
October 16, 2019 at 2:57 pm
Yeah....I missed that step..we need to build the .sln and then deploy using the wizard. Thanks!
October 3, 2019 at 4:48 pm
Thanks, I guess the path is diff compared to what they mentioned for 2012
'\Microsoft SQL Server\130\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd'
September 18, 2019 at 4:16 pm
I have noted the things you have mentioned and will now take a look at the SP's and look for additional problems as mentioned.
September 18, 2019 at 2:00 am
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...
September 17, 2019 at 6:02 pm
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"
September 17, 2019 at 5:02 pm
Thank you! for the guidance. It helps.
September 12, 2019 at 5:11 pm
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...
August 21, 2019 at 6:33 pm
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...
August 21, 2019 at 6:09 pm
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.
August 20, 2019 at 4:22 am