Browse by Tags

What is Parameter Sniffing? First of all, don't be scared about parameter sniffing. It's an expected behavior. When a stored procedure is compiled or recompiled, the parameter values passed for that invocation are "sniffed" and used for cardinality estimation. The net effect is that the plan is optimized...

Qu'est ce que le Parameter Sniffing? Il ne faut pas avoir peur du " parameter sniffing" . Il s'agit d'un comportement normal du moteur . Lorsqu'une procédure stockée est compilée ou recompilée , les valeurs des paramètres sont «reniflées» et utilisées...

¿Qué está el Parameter Sniffing ? No tenga miedo del "parameter sniffing". Este es un comportamiento normal del motor. Cuando un procedimiento almacenado se compila o se vuelve a compilar , los valores de los parámetros se " olió " y se utiliza para la estimación...

Problem description SQL Server Management Studio spends over 10 seconds to load. Cause In general, this behavior is due to 2 things: 1. The host computer not has access. By default "SQL Server Management Studio" is configured to use online help resources. 2. The host computer not has access. SSMS tries...