Hello Brandy,

MS Updating statitics

https://learn.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver16

MS When to update:

https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16#UpdateStatistics

Normally the default autoupdate will do unless in very specific cases ( you can find non-ms articles about this)

Even then you would...

Can you give some sample data and expected layout

You may want to use a datetable in your dataset so that every day of the months is in your dataset on...

Some reasons for avoiding nested views is:

It makes it harder to the optimizer to calculate a good execution plan (work strategy) because there are more possible combinations.

It may hide non-sargable...

Oracle isn't the easiest database to learn sql on but they do have an online course Oracle Database 19c: SQL Fundamentals https://learn.oracle.com/ols/home/sql-and-plsql-fundamentals/88387

A poor man's solution: logon-triggers https://www.sqlshack.com/prevent-sql-server-login-authentication-scope-using-logon-trigger/

can't really help you further

you may want to check out https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/tls-and-sql-server-reporting-services-an-interesting-interaction/ba-p/2477049 regarding TLS 1.0

or find another clue in the reportserver logs

There are different levels of timeouts

Connection timeout

Command timeout

Remote query timeout

Can you provide some background?

"Could not establish trust relationship for the SSL/TLS secure channel"

If you browse / upload to SSRS. Is that using https or http. Is the SSRS certificate or...

Depends on the access pattern. Usually one clustered index per table is preferred to prevent ghost-records.

I suggest watching https://www.brentozar.com/training/think-like-sql-server-engine/ for an introduction how sql server works and when sql...

I've found this https://learn.microsoft.com/en-us/answers/questions/1848448/unable-to-process-the-existing-user-settings-and-w

Mentions repairing .NET installation and moving the current user settings xml to generate a fresh set

Hello Goodtimecharlie,

Can't tell you about a busy AG system or clusters.

We're using Veeam for a SQL Server standalone. I/O freezes about 4 seconds on our busier systems. So far transactionslog...

Is there a way to commit the transaction log after a proc executes, so the log doesn't fill up and kill the job:

Smaller transactions: as long the transaction is running...

Thanks for this topic. Looking forward to the next one

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

if it is nvarchar it should be WHERE param=N'p1'  instead of WHERE param='p1'