Azure SQL database – How to solve parameter sniffing problem in a query with the & # 39; operator in & # 39;

I have a problem with parameter sniffing Azure SQL Server Query with in Operator:

    Select Col1, Col2, ..., Coln from T1 Join T2 
    On T1.Id = T2.T1Id
    Where T2.Col2 in ('uniqueIdentifier_1','uniqueIdentifier_2',..., 'uniqueIdentifier_m')

I have about 30-40 unique identifiers in the where clause. And I can't replace them because they are primary keys from another table in another Azure SQL Database. As you can see, there are a number of different unique identifiers and it is difficult to match them.
Would you please guide me to solve a parameter sniff problem?

Equation solution – Find the minimum value of the parameter

I solved the following nonlinear ODE:

   (*u'(t)=u^2(t)+1, 0

and got the following approximate solution:

  u2 = h - (-1 - h^2) t + h t^2 + h^3 t^2 + t^3/3 + (2 h^2 t^3)/3 + (
       h^4 t^3)/3

Then I calculate the residual error to check the accuracy by:

     Subscript(r, 2)(t_, h_) = !(
      *SubscriptBox(((PartialD)), (t))u2) - u2^2 - 1

and I got:

      h^2 + 2 h t + 2 h^3 t + t^2 + 2 h^2 t^2 + 
      h^4 t^2 - (h - (-1 - h^2) t + h t^2 + h^3 t^2 + t^3/3 + (2 h^2 t^3)/
       3 + (h^4 t^3)/3)^2

I have to get the value of h that gives the remaining minimum.

Thanks a lot

magento 1.9 – product list pagination missing second parameter (/category1/category2.html)

I created a custom module to handle filters by two categories:

Sharing and phones are both categories.

The router is working properly. I filter the product collection according to the categories "approval" AND "phones" _getProductCollection Method of Mage_Catalog_Block_Product_Listand it works too.

But there is something wrong with the pagination.

When I visit the previous URL, the pagination links look like this:

Page 1 –

Page 2 –

Page 3 – (and so on)

Why is the second parameter (telephone category) missing?

sharepoint online – How does the OverrideViewXml parameter work with ViewXml in RenderListDataAsStream in the rest API?

I'm working on getting data from the SharePoint list using the RenderListDataAsStream endpoint.
I first get all the views defined for the list and display them in a drop-down menu on the user interface. The user then selects the view

  • I get the ListViewXML for this view
  • Create a custom filter query like ...

and then pass this ListViewXML as ViewXML and custom filter as OverrideViewXml in body parameters for the remainder call of RenderListDataAsStream.

From here it says that OverrideViewXml is for

Specifies the overriding XML to be combined with the View CAML. Only applies to the query / where part of the view CAML.

I want to know exactly how OverrideViewXml works in conjunction with ViewXml. If I specify ViewXML, the OverrideViewXml query is ignored or does not work. If I only specify OverrideViewXml and not ViewXml, the OverrideViewXml query works. At the moment there are no results (whether "ANDing" or "ORing") from OverrideViewXml with ViewXML.

For remaining calls I use the PNP JS library (2.0.3) and the solution is in SPFX

st.statistics – How to find the maximum likelihood estimate if the value of the estimate is outside the range of the parameter

Since X1, …, Xn are independent, identically distributed Poisson (λ) variables, we know that the maximum likelihood estimator of λ = X̄.

Assuming X̄ = 2, and if λ can only take values ​​in (0,1), what is the maximum probability estimate of λ?

Python – Gets the object instance from the parameter

It is possible to find the instance of an object using a precisely defined parameter.

class Viaje(object)
    def __init__(self, nombre, id_doc, lista):
        self.nombre = nombre
        self.id_doc = id_doc
        self.contador = 0
        self.lista = ()

Another function that does not belong to the class and that I cannot change gives me that id_doc

def on_snapshot(doc_snapshot, changes, read_time):
    print(doc_snapshot(0).to_dict()) #Obtención de id_doc   
    for doc in doc_snapshot:
        print(u'Cambio en el documento: {} de {}'.format(, doc.get('Nombre')))
        class_viaje.contador = class_viaje.contador+1

Is there a way to get the reference to the entire object with the received ID in order to be able to edit its attributes?

Reporting – Keep SSRS report by URL with parameter value AND full main menu

TL; DR: How can I link to an SSRS (2016) report via URL with a parameter in the query string AND display (display) the FULL MENU bar (the top "SSRS Chrome" with the favorites, browse, keep)? Settings, breadcrumb navigation, etc.).

Why: I issue an old 2008R2 instance by putting a clickable link on the old RDLs to new versions of similar reports in the 2016 instance. If the user has selected / entered a parameter value, I would naturally like to forward this to the new report if possible. I followed the dox and created the url like this:


or the non-coded, more readable version:

http://ssrsInstance/ReportServer/Pages/ReportViewer.aspx?/Folder Name/Order Line Details&rs:Command=Render&OrderNo=123456

This works in that the report is displayed with the completed parameter values, but NOT the top-level SSRS menu section, ie the branding (logo / title), the Settings / Download / Help buttons in the top right. and the Favorites & Browse links on the top left. I WANT This stuff is displayed because it tells them that they are in the new reporting system and can navigate and find other reports.

What else I tried: Just use the report's & # 39; standard & # 39; URL (like navigating from the menu in the new instance) and append the parameter to the end as follows:


or for the uncoded version:

http://ssrsInstance/reports/report/Folder Name/Order Line Details&OrderNo=123456

This leads to an "Invalid element path" error:

The path of the item '/Folder Name/Order Line Details&OrderNo=123456' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

And of course the other (less cheap) option is to just use this URL without the parameter, but that forces the user to have to do the job again (especially with more complex parameter sets and multivalued parameters), which would be shit.

Hope there is a way! Thank you all. 🙂 🙂

7 – Why do D7 form builders have a $ form parameter?

In Drupal 7, the first parameter of a form builder function is $ form.

When implementing a Form Builder function, you can either add and return content to this existing array or create a new $ form array, discarding what has been passed to the function. In my experience, both options usually work fine.

What's the point Is there ever a case where this parameter is needed?

I vaguely remember to think that this is somehow relevant when a form is newly created, so this would be the old form. But I wouldn't really know what to do with it.

Note: The same question already exists for Drupal 8, but it seems to be a guideline here that we need different questions for D7 and D8. I wanted to answer it for D7, and I realize that it wouldn't be on the D8 issue.