I am trying to rewrite a stored procedure to Natively compiled stored procedure. The procedure refers to 20 tables, these tables are normal tables (non memory optimised) and I am using 5 views related to it. Is it possible to create a Natively Compiled stored procedure without converting any of these objects to Memory optimised tables?
Using non memory optimised tables in Natively Compiled Stored Procedure without custom table types
890 Views Asked by Rohith At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in SQL-SERVER-2016
- Select Columns with prefix
- Run SSIS package through Server its working fine but that package I am running on my local system its not working
- Degraded performance when inserting records in batches into a table with columnstore index
- Select substring of multiple rows with similar values
- How delete in specific order
- The 'Other Data Source' button is not activated when creating a SQL Server linked server
- Why can't I combine two SQL Server functions?
- How do I revoke a SELECT permission on one column of a table and still allow the user to do a SELECT * FROM the table?
- Why can't SQL Server Agent be started?
- Properly implement DENSE_RANK() or similar function
- Powershell SQL module errors out when trying to use sqlserver cmdlets
- How do I make one trigger fire but ignore the actions done by another trigger?
- Conditionally execute a query
- Issue with embedded text qualifier
- How do I create log of running balance of debits associated to the credits
Related Questions in OLTP
- Why some of existing user not able to see newly added DB in clickhouse
- OLTP-STAGGING-DW-DUPLICATES
- OLAP vs OLTP - Fundamental difference
- How to send authenticated traces to tempo cloud using OLTP exporter python?
- How measure attributes values are populated in fact table?
- Best practice to size Autonomous Transaction Processing (ATP) (number of OCPUs) for APEX on ATP?
- OLAP architecture?
- What do Transaction means in OLTP?
- OLAP/OLTP: What does "online" mean?
- OLTP type data in a OLAP system
- Data warehouse - OLAP vs OLTP vs Dimentional model vs Relational model
- Google Cloud Architecture: Can a data lake be used for OLTP?
- MS Access get row ID of Update or intercept Update
- How deep to go when denormalising
- creating SQL memory table visual studio
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Natively compiled procedures cannot access non-in-memory tables.
See Aaron's answer here: https://dba.stackexchange.com/questions/180172/use-natively-compiled-stored-procedures-in-disk-based-tables.