Viewing 15 posts - 1 through 15 (of 16 total)
I've compared the execution plan.. it looks the same. I don't see any difference.
October 28, 2020 at 2:07 pm
THis is the error I get
Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 3602, state 251, severity 25. This is a serious error condition which...
October 27, 2020 at 2:38 pm
If that is the case..how do I know the exact reason for the slowness?
October 23, 2020 at 2:01 pm
I am seeing a lot of PAGEIOLATCH_SH wait types when the sp runs.
October 21, 2020 at 4:13 pm
Thank you I got the first one working. Still trying to figure out the multiple outputs one.
January 28, 2020 at 7:47 pm
We have a requirement that we are not allowed to make any changes in the application connection string.
Does setting RegisterAllProvidersIP to 0 similar to MultiSubnetFailover=True?
August 19, 2018 at 10:56 am
Thanks for your reply.
From what I understand you used DNS alias to point to the alwayson listener name.We too have series of DNS alias name pointing towards...
July 24, 2018 at 8:02 pm
So after the failover has occurred, I should map the logins to the database?
August 18, 2016 at 12:53 pm
That was so simple. Thanks
May 3, 2016 at 8:53 am
sample data in A
[highlight="#ffff11"]GUID FBNUM ...
March 22, 2016 at 1:22 pm
Thanks for you reply
The fields in A table are truncated and populated with new data every week
all other fields might match but the date field doesn't
Not only the first...
March 22, 2016 at 12:57 pm
February 10, 2016 at 11:45 am
Thank you for all your effort.
I just want to remove that particular record. It's not always on the first row, it can be anywhere in the table.
September 9, 2015 at 7:24 am
I have so many NOT IN conditions like ::
Select * from backups
databasename not in (select databasename from backups where servername ='d900'...
September 8, 2015 at 2:06 pm
We use 2012. I dont think my organization agrees to that, they only have a requirement to encrypt 2-3 columns of a table. I think TDE is for the data...
December 10, 2013 at 12:04 pm