What SUBSTR() or IN is faster in Oracle?
Would WHERE SUBSTR(my_field,1,6) = 'search' or WHERE my_field IN ('a','b','c','d','f') be faster in Oracle, or would there be no difference? I cannot create temp tables and haven't got the execution plan. Thank you in advance!
How to change MS SQL services password (without locking an account out..?)
Hello ALL We have a very strange situation and I need your advice. We have AG of two servers and...somebody have missed an SQL Server service account password. Nothing critical, test envirounment. We have changed user's password in AD Users and…
CDC for Oracle by Attunity - license/support
Hi. We need help on questions regarding CDC for Oracle by Attunity (Service/Designer) from Microsoft Do we need to get a license from Microsoft in order to use this product? (we are currently testing the product with the Service/Designer clients) …
Begin tran and row lock
Hi, I'm using begin tran in my code and with this command - I update a row, it locks the whole table, but i want to lock only the updated rows. any idea?
Parallelism when execution cost lower than Cost of parallelism
why is that.? my cost of parallelism is default 5
Trancate table and LOB data
where there are still LOB allocation unit after the table is truncated ?
How to upgrade SQL 2017 Evaluation to Developer
How do I upgrade SQL 2017 Evaluation to Developer? I have installed SQL 2017 evaluation edition and been using it for 188 days while I waited for approval to purchase the developer edition. There is not a SQL product key available to insert.
Rebuild index on a 5TB database
We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild index on first chunk, then on the next chunk and so on. Please let me know
sys.dm_tran_version_store how to check which row from the table
How to check sys.dm_tran_version_store how to check which row from the table the records are originate from which row from the original table ? and from which transaction ?
Containment (Simple) vs Containment (base):
Containment (Simple) vs Containment (base): Containment (Simple): Users query for data that exists. For example, for an equality join between two tables, factor in the predicates selectivity1 in each input histogram, before joining histograms to…
Online rebuild index ABORT_AFTER_WAIT = NONE
ALTER INDEX clidx ON parttable REBUILD WITH (ONLINE=ON (WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 5 minutes ,ABORT_AFTER_WAIT = NONE))) So in this case, the rebuild index will wait for another 5 minutes, if it was first blocked already by…
Select between GDR and CU
I have Sql server 2014 in always-on , When i did Microsoft security upgrade primary shows as (SP2-CU18) and secondary shows as (SP2-GDR). Why there is a difference as primary is CU and secondary GDR.? historically primary was upgrading only CU and…
Improve the execution time for a complex SQL Query from 25 seconds to be under 1 second in SQL Server Enterprise 2019
How can I improve the execution time for a query where the initial Rows in the view were: 16000 and the query worked resonable ( under 1 second ), but now there are : 42487 rows in the View and the execution time is over 25 seconds ... which is not…
pkg goes down because a connection cant be found
hi we run 2014 standard and develop in vs 2013. i deployed a pkg that has no connector called xxxxxxxx.yyyyyyyyyyy but i get the error the connction xxxxxxxx.yyyyyyyyyyy is not found...oxc001000e...this error is thrown by connections collection when…
SCCM 2019 - Installation of WSUS - SQL
Dear all, I am trying to install SCCM as we aquired the licences. Now what I am trying to do is to install the WSUS role in the "SCCM Server". I can successfully connect to the sqlserver\sccm (the instance) but then when I launch…
SQLExpress 2017 upgrade to SQLExpress 2019 fails with message "Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available"
20573-summary.txtI am trying to upgrade my SQLExpress 2017 to SQLExpress 2019. It failed due to Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available. It looks like failed to open, create and copy registry between…
Criar um cursor que atualiza um campo char na tabela ESCOLA
Olá, estou tentando criar um CURSOR para fins didáticos que atualiza um campo Char na minha tabela ESCOLA conforme a quantidade de níveis de ensino na tabela ESCOLA_NIVELENSINO. Qualquer ajuda é bem vinda pois a ideia é eu fixar bem o conhecimento,…
SQL Server Backup Encryption Details
Hello, The Backup Encryption page mentions AES 256 can be used for encrypting backups. However, it does not go into IV generation, Cipher block mode, or Authentication of backups.…
Azure : SSRS Report Server : Image files bulk upload
Hello, I have created azure release pipeline to upload files, and looking solution to bulk upload .png files on report server. In a release pipeline, the SSRS task can upload only .rdl files, not .png. It gives MIME type error. Could you please…
dynamic configuration ssdt
HI, i need to know if w can change provider and server name without opening and manually changing in package. i have server name in parameter but not provider (sql client 11.1) i want to change this in 100 package , without opening it , or doing it…