Viewing 15 posts - 1 through 15 (of 1,974 total)
Also, MS has a specific client https://www.oracle.com/database/technologies/appdev/ocmt.html that eases installation for powerbi.... may be worth a try
September 5, 2024 at 9:43 am
if it is nvarchar it should be WHERE param=N'p1' instead of WHERE param='p1'
August 29, 2024 at 9:55 am
That's odd, I would expect better performance because it can sniff the hardcoded value and use it for the query plan.
Perhaps the hardcoded value is not the same datatype as...
August 29, 2024 at 8:07 am
Why are you not memory capping SQL Server in order to leave some RAM reserved for OS / other applications ?
August 22, 2024 at 9:48 am
Have a look at https://www.sommarskog.se/query-plan-mysteries.html
Slow in app / fast in ssms symptom
Like when debugging you may have setted the variable to literals which sql server can sniff for a...
August 22, 2024 at 9:46 am
As you mention it happens in ssms too
it also coud be "parameter sniffing" https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/
August 12, 2024 at 8:35 am
Looks like "runs fast in ssms but slow in application"
check ms documentation https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-application-slow-ssms-fast
August 9, 2024 at 10:37 am
With modern storage I would skip index maintenance as Jef mentioned in that thread. So many layers and can be quite costly in the cloud
Most important is having correct statistics....
August 8, 2024 at 3:13 pm
Sounds like what I've read earlier today about automatic tuning
Also, when a plan is forced , it is allow to compile longer?
https://littlekendra.com/2024/01/17/automatic-plan-forcing-could-be-great-but-isnt-sql-server/
August 7, 2024 at 3:01 pm
Dateformats ?
Empty or Invalid "To" when emailing ?
July 30, 2024 at 8:11 am
The latest thing thrown around is MS Fabric.
Found a page about the differences between Fabric and Dataverse https://fabriconelake.com/microsoft-fabric-vs-dataverse-comparison-for-microservices-and-data-management/
Our company is not that far yet to represent information as an unified...
July 24, 2024 at 12:44 pm
Luckily not, didn't know that CrowdStrike existed before it happened
July 23, 2024 at 8:32 am
search on "token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission"
most articles mention logins & service principal names.https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/ Mentions checking for deny permissions
July 22, 2024 at 10:18 am
That's how we did it. Most important things are the encryption keys
July 11, 2024 at 7:59 am
I've found https://www.sqlservercentral.com/articles/migrating-sql-server-reporting-services
To migrate from 2014 to 2016. 2016 to 2019 should be similar.
Don't have experience with scale-out.
Beware, from 2017/2019 MS disabled multiple SSRS instances on the same server
July 9, 2024 at 3:46 pm
Viewing 15 posts - 1 through 15 (of 1,974 total)