question

ThomasRomeo avatar image
ThomasRomeo asked

How to set forced parameterization in SQL Azure

Using SQL Server on premise, I can issue the SQL Statement Alter database [myDB] set parameterization forced Or I can right click the database from SQL Server Management Studio and then set parameterization to forced from the options tab. I can do neither on SQL Azure - is this disabled on the platform? As a result, my stored procedures are really fast, but my ad hoc queries are really slow
sqlazure
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
That's one of several settings that are not available to you in Azure SQL Database. While it does have most of the functionality of the on-premises server, there are differences and you've found one.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRomeo avatar image ThomasRomeo commented ·
thanks - was driving me nuts - so I need to make sure that there are no ad hoc queries or at least limit them
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.