Viewing 15 posts - 301 through 315 (of 2,051 total)
Even if it is a dedicated SQL box, I would configure sql server max memory to ensure there is some ram left for OS , Antivirus, ...
February 18, 2022 at 9:46 am
I don't see an issue in using randomly generated PK names for temp tables
February 1, 2022 at 9:53 am
I'm also using SCOM 2019 and run into discovery problems. Usually when the DB is disabled.
Haven't the time for a full discussion but this may be a start.
https://docs.microsoft.com/en-us/troubleshoot/system-center/scom/troubleshoot-sql-database-discovery
The required...
February 1, 2022 at 9:48 am
Could be. Didn't got notified of your reply "are-the-posted-questions-getting-worse"
January 21, 2022 at 3:31 pm
The second will be better by skipping unneccessary data modifications / triggers. No point in updating billions of 999 rows to 999 rows where there are only 3 <> 999...
January 21, 2022 at 3:28 pm
Answers without samples
#1: joinorder doesn't matter. SQL Optimizer permutates join order in order to get the lowest cost plan. You can switch the join order in your statement. Beware Left...
January 21, 2022 at 3:17 pm
I haven't experienced major delays with Microsoft Authenticator sofar
January 20, 2022 at 12:51 pm
C# . It's mostly used by our devs. ( it helps translating ORM implementations ). Investing R / ML is on hold as you need quite a statistical background
January 14, 2022 at 10:11 am
I welcome the free toolset and hope it gets a place next to sp_WhoIsActive, FirstResponder.
Are there real world examples where the tool was used?
January 14, 2022 at 10:07 am
You may also try configure HTTP first and then switch to https
January 13, 2022 at 10:45 am
Not really.
Currently I have the following in PowerBI rsreportserver.config
<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>....../AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportServerWebApp</Name>
<VirtualDirectory>Reports</VirtualDirectory>
<URLs>
<URL>
<UrlString>https://+:443</UrlString>
<AccountSid>........</AccountSid>
<AccountName>NT SERVICE\PowerBIReportServer</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>
January 13, 2022 at 10:23 am
I would suggest setting max ram per instance.
As far I know SQL Server keeps consuming memory and never releases it, potentionally not leaving enough ram for OS, AV, ...
It can...
January 12, 2022 at 10:16 am
Thanks for voluntering. It's certainly helpful to make the skills more popular.
At Belgium we have coderdojo's to learn children to create websites, games, ... in the hope they will use...
January 3, 2022 at 4:25 pm
You've must have exhausted all other options. Maybe they have a six figure salary job opening
December 29, 2021 at 8:58 am
Viewing 15 posts - 301 through 315 (of 2,051 total)