Probably switch to PostGres or start developing again

Using some crude tracking with SP_DATABASE_TABLE_SIZE. Lately switched to extended events database file changes to identify the culprit or using query story to find the queries just before that happened

The newer os requires you to use administrative privileges (UAC). Run explorer as administrator

cmd (run as administrator)
explorer (this will be started as administrator)

explore

4 TB SQL backup may take a long time

Have you looked at backup snapshot technologies? Like Veeam / SAN ...

Nvidia drivers are under the weather, having an expensive video card to see black screens every so often.  Not feeling the burn yet

If you like the query results in VS Code below your query

Go to Menu > View > Editor Layout > Flip Layout.

Aargh, just got used to Azure Data Studio with its easy exports to CSV, JSON, Excel ...

Also using extended events voor basic monitoring, but the tooling is not easy.

I would also like something that is able to read it without using sys.fn_xe_file_target_read_file in order to offload...

Thanks for the replies

Hey,

Did you set the timeout on the command? It is different than the one of the connection

Dim command As New SqlCommand(query, connection)
command.CommandTimeout=300
command.ExecuteReader()

You may also read

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-application-slow-ssms-fast

Does anyone have experience with text search engines https://www.sqlservercentral.com/forums/topic/text-search-emails-and-other-json-items

We're trying to provide a solution to business they can use to detect when an certain email is sent according to their...

Depending on the update, you may add an index on the field being updated in order that sql server doesn't have to lock the whole table.

update ... where mycol =...

If you can figure out what Access doing in the background ( querystore / profiler / ...)

you may be able to optimize the query. Like adding an index on the...

You can probably speed the migration up with https://docs.dbatools.io/Start-DbaMigration.html#:~:text=Start-DbaMigration%20consolidates%20most%20of%20the%20migration%20tools%20in,of%20it%20as%20an%20easy%20button.%20It%20migrates%3A

(double)

• This reply was modified 11 months ago by Jo Pattyn. Reason: double entry due slow forum