December 31, 2017 at 3:08 pm
We're looking at converting several normal T-SQL Stored Procedures into Natively Compiled SPs for performance.
The SPs use a ton of #tmp tables - select into, delete from, update from, and several unsupported constructs like SUM/MAX/ROW_NUMBER OVER PARTITION BY, WITH, LIKE etc.
We have figured workarounds for many of these :
Select into - Create table type ahead of time
Delete from - use while loop as cursor
...
Is there a simple workaround for the OVER/PARTITION clause, other than separating the queries and then doing GROUP BY ?
Also, has anyone done large-scale conversion of SPs to Natively-Compiled and any roadblocks you encountered ?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy