Viewing 15 posts - 16 through 30 (of 2,919 total)
My next best guess is that something in the connection string is setting it (not likely as I don't think you can set that in there), in the driver (possibly),...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 13, 2026 at 5:25 pm
as a guess, I think that can be a default on the instance level (maybe database level), so it may be set on the server not in the web service.
Failing...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 11, 2026 at 9:53 pm
In case nobody wants to download the file, this is the content (I viewed it safely):
SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id)...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 5, 2026 at 9:35 pm
Just to add to hmbacon's reply, sometimes the problem isn't found during the deployment. I've had problems found days or weeks after deployment. Rolling back in those scenarios can be...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 5, 2026 at 3:10 pm
You asked if we got "desired results" - what results were you desiring? Are you looking for performance gains (or losses)? If so, turning compression on across the board will...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 4, 2026 at 2:07 pm
Just to add to what deubel_m said, Ola's scripts are not managed, maintained, or supported by SQLServerCentral. SOME users of this forum use them and can offer advice about them,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 3, 2026 at 10:01 pm
My opinion - if you don't have access to their systems, that means it is not your problem. You can't see how they have their script configured plus I doubt...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 2, 2026 at 8:24 pm
Another thing - like Steve Jones said - having the API server just moves the load. If the API server caches things, you run the risk that the API server...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 23, 2026 at 7:42 pm
Another question for you is what problem are you trying to solve and how will you know it is solved? "Too many connections" is very arbitrary and not helpful. BUT...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 20, 2026 at 8:24 pm
Probably a dumb question, but you created a key correct and updated the instructions to use your key not the example one they have in their sample scripts, correct?
What I'd...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 12, 2026 at 6:46 pm
Also, just to confirm but I suspect you are right with the CASE statement, but is it the CASE statement or the date comparison that is slow? If it is...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 9, 2026 at 10:04 pm
Probably a few dumb questions but:
1- did all of the installs succeed or did any give errors?
2- you installed the connectors on your local machine AND the server, correct? Local...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 3, 2026 at 4:14 pm
I was reading up a little bit on this and it's not the greatest news for sure. PBIRS requires a PBI Pro license to develop reports and that doesn't come...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 28, 2026 at 8:54 pm
My advice - check all of the logs. On the primary and on the secondary. The SQL logs, the event logs, every log you can find. Start with the Cluster...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 22, 2026 at 2:50 pm
Sounds like a bug to me. I'd reach out to Microsoft about it and see if there is a fix or known workaround.
That being said, looks like someone reported this...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 19, 2026 at 8:43 pm
Viewing 15 posts - 16 through 30 (of 2,919 total)