Viewing 15 posts - 91 through 105 (of 2,339 total)
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
That would make a very viral video!!!!!!!!!
August 15, 2023 at 6:40 pm
As an example, I have a job the runs nightly index rebuilds on the primary. If the primary fails over and becomes the secondary then all those jobs fail....
August 15, 2023 at 1:26 pm
Funny that this popped up. As I was working through an issue with a colleague, he did a google search. The first result was SO. And, the answer provided was...
August 14, 2023 at 4:56 pm
Did you not read my error message?
Yes, and we are confused as to what you are trying to do.
If a job is already executing, and a planned failover occurs,...
August 14, 2023 at 3:10 pm
I would speak to your network people. It smells like DNS and/or Kerberos.
ps Also, double check you have no SQL Server alias on you application servers.
I second this.
August 8, 2023 at 1:37 pm
Are the SQL services set to automatically start in SQL Configuration Manager? That needs to be set to manual. The cluster controls starting the SQL Services.
And, the error message is...
August 7, 2023 at 1:25 pm
I'm 100% remote. My company is located 450 miles away.
I go into the office when there are things like parties, golf outings, and such.
There is definitely a "hole" being 100%...
August 4, 2023 at 7:50 pm
I read a lot about index maintenance, but I think, I need a second life to understand everything.
Andreas, we had this revelation about 5 years ago. Jeff, Ed, and...
August 2, 2023 at 2:36 pm
This is the code being used by Ola's scripts to get the fragmentation. In the proc, this is dynamic SQL.
SELECT MAX(avg_fragmentation_in_percent), SUM(page_count)
FROM sys.dm_db_index_physical_stats(DB_ID(@ParamDatabaseName), @ParamObjectID, @ParamIndexID, @ParamPartitionNumber,...
August 1, 2023 at 12:51 pm
deubel_m wrote:Hi Andreas, how large is the sysjobhistory? Can you manually rebuild the index?
Same question. What problem is being solved by rebuilding the indexes?
The problem is not...
August 1, 2023 at 3:48 am
Its 1033 pages, I already started going down that thought train then saw he posted its size.
That close to the lower limit for it rebuilding in indexOptimize, (which is...
July 31, 2023 at 10:40 pm
Hi Andreas, how large is the sysjobhistory? Can you manually rebuild the index?
Same question. What problem is being solved by rebuilding the indexes?
July 31, 2023 at 6:10 pm
Why are you trying to rebuild or reorg the indexes? What problem are you attempting to solve?
July 31, 2023 at 1:35 pm
Go with Kingsway. It works very well. Been there, done that.
July 27, 2023 at 2:12 pm
check if UDP 1434 is open - not sure if that was included in 'checking if the network settings are correct.'
Also confirm if the correct network profile is active....
July 24, 2023 at 5:03 pm
Viewing 15 posts - 91 through 105 (of 2,339 total)