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 9 months ago by Jo Pattyn. Reason: double entry due slow forum

Download the installation media of sql 2019 developer and startup setup. You may get the option to repair / uninstall it

Sorry for the delay, got sick

Have you tried tilde processing? https://www.onbarcode.com/qr_code/

section Encoding ISO-8859-1 Chars and ASCII Control Functions in QR Code Barcodes

Haven't done it yet. Have you tried \t

that is the tab notator for c#

or CHAR(9)

that is tab for T-SQL

Have a look at https://www.sqlservercentral.com/forums/topic/microsoft-recommendations-for-update-stats There is a whole discussion why you should not rebuilding / reorganizing indexes unless necessary

Hello Brandie,

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...

• This reply was modified 10 months ago by Jo Pattyn. Reason: Corrected name

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