Ι have the following view: CREATE OR REPLACE VIEW public.my_view as SELECT col1, col11 from table_a JOIN table_b on table_a.id=table_b.a_id join ( select id,col56 from table_c where col56 > 3 ) as filtered_c on table_a.id=filtered_c.a_id; table_a is: id: SERIAL PK col1: INTEGER table_b is: id: SERIAL PK col11: INTEGER a_id FK table_a table_c is: id: […]
Author: Jessica Alba
Whether your next job interview is related to data science or machine learning, you can bet that artificial intelligence questions will come up.
I have a folder of scripts that contain multiple objects and jobs that I roll out every time I deploy a new SQL Server Instance. The scripts utilize scripting variables, as an example, here is an abridged example of a job creation script: DECLARE @Owner SYSNAME = (SELECT [name] FROM sys.server_principals WHERE [sid] = 0x01) […]
FK Constraint error
I am in the process of setting up a replication between my production server and a secondary. The two machines connect to each other perfectly and I think I set things right. I dumped my prod that I injected into the secondary, but at the start, I got the following error: mysql> SHOW SLAVE STATUS\G […]
I have two questions about the index management of MS-SQL-Server 2019 If the term "table scan" appears in the execution plan, is that an indication of a "full table scan", and that means that no index has been used here? This is the execution plan I’m never sure if MS-SQL will use my indexes. But […]
I need help understanding my options. Given: SQL server cluster setup that is maintained by a DBA. System is NOT in production yet (not handed over to the customer). Initial high volume push of data that has NO breaks for days I can stop and start the push of data and change the database at […]
I’m asking this question as a end user not a Knox cloud admin. Bearing this in mind, I’ve finished the first initial setup without allowing the device to connect to the Internet (and thus couldn’t be aware of any possible Knox enrollment prompt). And now I would like to discover if this device is already […]
I have two questions about the index management of MS-SQL-Server 2019 If the term "table scan" appears in the execution plan, is that an indication of a "full table scan", and that means that no index has been used here? This is the execution plan I’m never sure if MS-SQL will use my indexes. But […]
How does pagination work with orderBy: ‘RAND()’ queries? I’ve setup a page that loads assets on scroll. If I’m ordering by random, how does offset:2 work? Is each query a new random selection from all assets, in which case repeats are possible? Should I be passing in asset IDs somehow to exclude already returned assets?
I have two questions about the index management of MS-SQL-Server 2019 If the term "table scan" appears in the execution plan, is that an indication of a "full table scan", and that means that no index has been used here? This is the execution plan I’m never sure if MS-SQL will use my indexes. But […]
The title is self-explanatory and it is referred to changing configurations, (dis)enabling schemes/roles/accounts, etc.; that is, making the cluster more "secure".