Azure SQL Blog

Options
3,224
MarisaMathews on Jan 19 2023 11:42 AM
1,338
MarisaMathews on Jan 19 2023 11:10 AM
4,096
NevenaNikolic on Jan 13 2023 08:21 AM
1,568
MarisaMathews on Jan 12 2023 10:34 AM
1,615
MarisaMathews on Jan 05 2023 09:20 AM
42.3K
uc-msft on Jan 03 2023 12:00 AM
2,953
RieMerritt on Dec 28 2022 11:35 AM
2,425
MarisaMathews on Dec 22 2022 09:00 AM
3,005
AndreasWolter on Dec 20 2022 01:32 PM
1,770
MarisaMathews on Dec 16 2022 09:00 AM
3,258
Anna Hoffman on Dec 14 2022 09:30 AM
1,156
MarisaMathews on Dec 13 2022 09:00 AM
1,044
MarisaMathews on Dec 08 2022 09:00 AM
3,184
ajith-k on Dec 08 2022 12:29 AM
1,679
MarisaMathews on Dec 02 2022 10:12 AM
4,062
scott_kim on Nov 30 2022 10:05 AM
2,313
scott_kim on Nov 30 2022 10:05 AM
2,566
UrosMilanovic on Nov 30 2022 08:32 AM
1,568
MarisaMathews on Nov 29 2022 10:49 AM
2,953
AndreasWolter on Nov 23 2022 03:34 PM
882
MarisaMathews on Nov 17 2022 09:00 AM
2,233
erinstellato on Nov 16 2022 10:30 AM
3,917
milanlazic on Nov 16 2022 09:45 AM
3,444
Anna Hoffman on Nov 16 2022 09:00 AM
4,187
Borko_Novakovic on Nov 16 2022 08:04 AM
8,677
Vladimir Ivanovic on Nov 16 2022 08:03 AM
6,459
Mladen Andzic on Nov 16 2022 08:03 AM
2,750
sasapopo on Nov 16 2022 08:03 AM
2,793
sasapopo on Nov 16 2022 08:01 AM

Latest Comments

@scott_kim Are there limitations or gotchas with preview? We've done some testing and found a distinct improvement. Is there any reason we wouldn't move forward with this on a subset of production databases?
0 Likes
This is a rather old thread, but wondering what the roadmap for this product is? Haven't seen any updates in a while and wondering if there are any plans for key rotation.
0 Likes
Hi @Francesco_beqom Just tini clarification... I am pretty sure that you meant "Accuracy" which is what @Balmukund Lakhani answered, and not "Precision" even so the question regarding Precision is legit as well. Accuracy refers to how close a measurement is to the true or accepted value. Precision r...
0 Likes
Hi @Francesco_beqom Thanks for the comment. We have documented that these functions provide rank-based error guarantees not value based. The function implementation guarantees up to a 1.33% error. So basically, if you arrange them in order then rank wise, result might be off max by 1.33%.
0 Likes
"[...] where response time of percentile calculation was more important than the accuracy of the result." Now I'm glad you show the statistics about how fast this implementation is. However I would have loved an example of the precision that we are going to lose shifting to APPROX_PERCENTILE_CONT. A...
0 Likes